Page 1 of 1

Automatic scale based on series

Posted: Mon Mar 27, 2006 8:30 pm
by 9079179
Hello,

I have several series on my chart. My chart is set to automatically scale. I wish to automatically scale based on a certain series and disregard the other series; however I need the other series to be visible on the chart.

To further explain, I am drawing a horizontal line as a series. The is a reference line. I have another line that varies up and down. The chart should scale according to this line and NOT the value of the horizontal line when set to automatically scale.

Thanks!

Posted: Tue Mar 28, 2006 8:20 am
by narcis
Hi Jeff,

To achieve that you could assign a different axis to the series you don't want to influence on the scaling and make that axis not visible. I.e.: If one series has left and bottom axes associated you could associate the other series right and top axes. If you are already using those axes then you can add custom axes to your chart.