Stock charts - adding extra data series

**alexisjohansen** · 08-26-2008, 06:25 AM

I want to create a stock chart - open/high/low/close - to which I can add one or more lines based on additional data that I have derived.

Does anyone know if this is possible in Excel 2007? So far, I've attempted to combine the OHLC stock chart with a line chart, and it tells me that these are incompatible.

Thanks.

**Andy Pope** · 08-26-2008, 06:42 AM

What sort of additional information are you trying to add and what chart type?

Can you post example.

**alexisjohansen** · 09-02-2008, 06:21 PM

Hi Andy,

It's just a stock chart (based on 4 series of data - open/high/low/close) and I want to overlay various lines, based on further columns of data that I have created (e.g. the 20 day maximum of the stock prices, the 50 day moving average, etc.).

As I understand it, Excel 2007 prevents one from combining a stock chart with a line chart in this way. The only thing option that I can find in the help section is that of adding a trend-line or other pre-defined line from some finite set. This is not sufficient for my purposes.

Thanks.

**Andy Pope** · 09-03-2008, 03:56 AM

I created a stock chart as normal.
Add 2 extra series and then moved those to the secondary axis.

**alexisjohansen** · 09-08-2008, 07:37 AM

Thanks Andy,

That's absolutely perfect.

Sorry for the late replies - I don't check in here very often.

Alexis

**pjdalb** · 06-04-2010, 03:36 AM

Hi Andy or anyone that can help.

Could you please explain how to do the following in detailed steps
"Add 2 extra series and then moved those to the secondary axis."

I am a raw beginner with excel and your excel sample is exactly what I am trying to do.

regards
PJ

**Andy Pope** · 06-04-2010, 03:51 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.