add horizontal lines to stock chart

**freak11** · 09-14-2013, 02:02 PM

Hi guys,
I have got several stock charts on my excel file in the same sheet. To each of those stock charts I want to add 8 horizontal lines whose y-axis values are derived from A1, B1, C1, D1, E1, F1, G1, H1. If the horizontal line is greater or lower than the highest point or lowest point in the stock chart then I want it to be ignored. At the same time I want to delete all the grid lines in the stock charts. Does anyone have a macro for this?

**2001jesper** · 09-14-2013, 03:05 PM

You should upload a sample workbook with the data, as this will make it easier to help you

**freak11** · 09-14-2013, 04:33 PM

Booking.xlsx I have attachd an example to make things clearer. Please ask me if you have any further questions. Thanks.

**Andy Pope** · 09-15-2013, 07:32 AM

the stock chart will not combine with another chart type that will allow you to draw the lines.

What you can do is build your own stock chart by using HiLo lines and Up/Down bars. Remove the actual line series formatting.
You can now add a xy-scatter series to the secondary axis and draw required lines.