Stock Chart - Open High Low Close + Volume

[hilss]

Hello,

is there a way to chart stock data with Open High Low Close (OHLC) and Volume?

I saw one option in Excel 2007, but i cannot separate the volume from the prices? For example, I want one chart with 2 graphs: the top to be the OHLC, and the sub graph to be the volume. Is that possible?

Is there a way to create to different charts and merge them together?

Thanks,
hilss

 

[Andrew Poulsom]

Look here:

http://office.microsoft.com/en-us/excel-help/present-your-data-in-a-stock-chart-HA001233750.aspx

The volume needs to be on a different y axis from the prices.

 

[hilss]

Thank you, but this does not plot the volume portion in the sub graph.
hilss

 

[Andrew Poulsom]

Sorry, I don't know what you mean by sub graph. In those charts volume is plotted as a column chart.

 

[hilss]

Well, thanks for your repsonse, but I'm not sure how to embed an image file in here... But I will try to represent it in text


|
|
| Main Graph
| the open high low close would be here
|
|
|
|
-------------------------------------------- time
|
| Sub Graph
| the volume will be here
|
-------------------------------------------- time

the x-axis for both charts would be the same... so it's as if you have two separate charts in one...

here's an example:
http://www.simple-stock-trading.com/uptrend.html

thank you very much,
hilss

 

[Andrew Poulsom]

Maybe this will help you:

http://peltiertech.com/Excel/Charts/StackedCharts.html

I'm not sure you can mix the chart types though.

 

[hilss]

That is very kind of you. I will give it a shot and mess with it a bit.

Once again, thank you,
hilss