Add Horizontal line to stock chart

**4dplane** · 02-25-2011, 06:41 PM

Hi,

I am using the the stock chart and I would like there to be a horizontal line across the chart with a y-axis of the opening price. In the end I want this to be in VBA but I think if someone can show how to do this manually I should be able to put it in loop of data that will produce many charts with a horizontal line starting at the day opening.

I have tried to add a new series to the chart but I'm using the Candle stick stock chart and the new series comes out as a vertical not horizontal line. I read about using a secondary horizontal axis but all the tutorials I find are in Excel 2003 and they donlt line up well with Excel 2007.

Any thoughts on how this is done?

I found this link on charts with horizontal lines but again they are in 2003 and I'm using a candle stick stock chart not a scatter chart.
http://www.tushar-mehta.com/excel/ch...traight_lines/

Thanks,
4dplane

**6StringJazzer** · 02-25-2011, 09:06 PM

The stock chart is hi-lo-close for a series of days, but you refer to the "day opening." Do you mean that you want a horizontal line for the value of the opening of the first day?

A stock chart cannot be combined with other types of charts (the example in your link show two types that can be combined).

One workaround is to create two charts, then make the background on one transparent and overlay on the other chart. Crude but effective.

**Andy Pope** · 02-26-2011, 07:14 AM

Instructions are in attached file.

**4dplane** · 02-26-2011, 12:42 PM

Thanks to you both... Andy your file example was A+.

In the ended, I used two graphs on top of each other reason being is I want many lines not just the one.

Thanks,
4D

**Andy Pope** · 02-27-2011, 08:59 AM

I was able to add 251 lines. How many exactly did you want?

**mgroll77** · 12-19-2012, 03:48 PM

Originally Posted by Andy Pope

Instructions are in attached file.

In the Excel file example, the third line of instruction is, "Select Horizontal Line series and move to secondary axis." What is the secondary axis? How do I do this?

**6StringJazzer** · 12-19-2012, 08:51 PM

I hate it when I say something can't be done and Andy does it.

Anyway, you will see in the third and fourth chart to the right in the example file that there is a y-axis on the left, and a y-axis on the right. The y-axis on the right is known as the secondary axis. You can have some data series that are plotted on the primary axis, and other data series that are plotted using the secondary axis. To move the line to be plotted on the secondary axis: