Automatic scale based on series

Jeff · Post by **Jeff** » Mon Mar 27, 2006 8:30 pm

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!

Narcís · Post by **Narcís** » Tue Mar 28, 2006 8:20 am

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.