Hi,

Rather than draw the lines over the chart make them part of the chart by
plotting them as extra series.
Have a look at this page for some examples and links to other sites.
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"anshu" wrote in message
oups.com...
Hi All,

I am generating a chart (Stacked Bar) where number of series is fixed
(6) but number of data points vary and as a result the scale of the Y
axis keeps on changing every time it is refreshed.

I also have three lines on top of the chart which I need to show to
define boundaries within which the data points should lie. One at the
origin (coinciding with X Axis), other at 50% and the last one at
-50%.

My Y axis will never go beyond 100% and -100% but because the X aixs
labels keep on expanding as I select more data to plot, the graph
moves up and down and the lines changes their position.

Is there anyway, I can keep the line static?

Please help

Thanks in advance
Anshuman