Same scale on both Y-axes?

[Scalpel]

Hi,

 

I'm using a "Combo Stacked Column 3D - Line DY" graph to display stacked financial data. The line from the right Y-axis is going to display target/budget.

 

 

 

I've got data displaying, but the two Y axes use different resolutions. How can I force the right Y-axis to use the same resolution as the left Y-axis?

 

 

 

Alternatively, can I drop the second Y-axis completely, but tell the Chart to draw one of the datasets as a line instead of being stacked on top of the bars?

 

 

 

Frode

[Mangalores]

If I remember correctly this chart xml looks like:

 

dataset

   dataset 

   dataset 

dataset 

 

resulting into a stacked column

 

 

 

By writing this I got two columns side by side in this swf:

 

dataset 

    dataset

dataset

     dataset

dataset

 

And line charts work with "lineset"

 

 

 

You can also control which axis a graph uses by setting some yAxis parameter to P or S (primary or secondary)

Edited April 30, 2009 by Guest

[Scalpel]

Hello, I'm not sure if I understand your answer.

 

 

 

Take a look at the attachment. The problem is that the line, which uses the Secondary axis, is displayed with another axis resolution than the primary axis. I want the line to be shown like the one I've drawn on the image.

 

 

 

The line is a line which marks the budget target for each salesman, and the three stacked columns should reach the line when the salesman has reach his planned budget.

 

 

 

Frode

[Tiggs]

I have exactly the same problem.

 

 

 

The issue is that I need to render a 3D stacked column and a line on the same chart.

 

 

 

Ideally, I'd like to use the same Y Axis, but there's no chart that renders a stacked column and a line on a single Y axis.

 

 

 

As such - StackedColumn3DLineDY.swf and MSStackedColumn2DLineDY.swf appear to be my only options. They both have Dual Y axis & I can't work out how to sync them, either.

[Dhruva]

Hello all,

I suggest you set the maximum and minimum limits ot the two manually to the same values, using the PYAxisMaxValue, PYAxisMinValue, SYAxisMaxValue SYAxisMinValue attributes in the chart element.

Please take care to ensure that the data points to be plotted lie within the range you set manually.

I hope this helps.

[Tiggs]

Thanks Dhruva, that's worked for me.

 

 

 

Scalpel - fyi - setting showSecondaryLimits='0' and showDivLineSecondaryValue='0' will remove the second axis display.

 

 

 

Tiggs

[Dhruva]

You're welcome!

[Brambilla]

This solution aparently doen't work with negative values.

I'm still after a solution for this problem for both positive and negative values.

[saptarshi]

Hello,

 

 

 

Stacked charts are intrinsically meant to handle positive data. Hence, their behavior in case of negative values may some times be unpredictable.