Hi again,
On my composite chart, I have currently have a combination of a Column and Spline chart.
The Column chart uses the X axis and Y axis and has Y axis values ranging up to around 1.4 million. The X axis has months in the year.
The Spline chart uses the X2 axis and Y2 axis. The Y2 axis has values ranging up to 200. The X axis again has months in the year in sync with the Column chart.
Now I want to add a third chart area which is another Spline. This Spline will have values ranging around the 30 million mark.
Is it possible to do this in this scenario? If so any pointers?
Andez
You can create a second Y2 axis (newY2Axis). Your new spline layer will use the same x axis as the other spline layer and this newly created Y2. Set newY2Axis.Extent to be different from the other axis, so that you can see both axes, otherwise they'll be on top of each other.
Cheers again max. I had that thought at the back of my mind and I've just implemented it as you said.
Just a thought on this... As I have 2 splines and 2 Y2 axis, is there a way to present it to the user which line belongs to which Y2 axis scale?
At the minute I've coloured each Y axis line to match the colour of the Spline.
Thanks