Excel:- maintain the relative positions of chart & hand-drawn-lines

Question

I have a stock-chart in Excel.
Certain highs & lows are connected by drawing a line manually (from the drawing toolbar).
When I change the data-range or resize the chart, the lines obviously stay in their original position.
And the bars in chart get resized.

Is there any way to maintain the relative positions of chart & hand-drawn-lines?
Maybe, merging the bars in chart with the lines drawn by hand?

Thanks,

Vineet

Answer 1

I found a solution for same.

http://www.excelforum.com/excel-charting/835738-grouping-chart-and-lines.html?p=2812431

-- Vineet