Want single Dual Axes bar chart scale for both axes which is dynamic.

[sreeramnavale]

Please help, I haven't been able to solve this issue that's been driving me crazy for some time, anybody familiar with charts in Crystal reports, specially dual-axes bar charts?

I need my dual axes bar chart to have the same scale on both y1 and y2 axes. As it is now, if for example on my Y1 I want to graph a bar with a value of 8 and on my y2 a value of 6, it is somehow putting my y2 bar much higher, obviously it is using a different scale, I want them both
to have the same scale. I'm using Crystal XI professional edition.

I am putting this chart in a group header.

So I want a solution which will have Max of range to be dynamic to the data which I want to display.

Thank you very much.

SN

 

[lbass]

If you just want the same scale on both sides, then do not set this up as dual axes. Instead, after creating the chart, select an axis value->right click->data(Y)axis options->layout tab->check axis on both sides.

-LB

 

[sreeramnavale]

LB, I looked at the approch you suggested. I am not sure if it will work(May be I am wrong).

As I should say that I did not explain everything of what I am doing.

Actually the bar chart is a Stacked Bar chart with dual axes.
Y1 axes having Small Bookings, Medium bookings and Large bookings of a perticular Quarter of year(Last Quarter).
And Y2 axes having Small Bookings, Medium bookings and Large bookings of another quarter of year(This Quarter).

Does you approch still work? If yes how?

Thanks,
SN