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?