Making Static Lines in Chart



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

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


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question