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