I have a dual stacked bar chart that I'm trying to have the Y1 axis automatically calculate and have the Y2 axis match these values. Does anyone know of a way to do this?

Thanks,
Clint

This message has been edited. Last edited by: capples,

Hi capples,

While we wait for others to reply ....

Can you provide a bit more information or even a screenshot of what you are trying to accomplish?

Or even the chart code of what you have so far?

That would help us to help you out.

Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator - Information Builders Inc.
* Summit 2016 – June 13-17 in Reno, Nevada  - http://www.informationbuilders.com/events/summit

Capples,

we had a similar problem, only we had two different graphs that needed the same Y-axis.

We just sampled the data to display.
Say you're reporting "turnover".

We queried 0.9 * MIN.TURNOVER and 1.1 * MAX.TURNOVER over the entire dataset.

Then rounded it to the nearest 1000. ( round-down for min and round-up for max ).
And used -READ to get the results in parameters.

Then used those parameters to HARDCODE the min and max scale of the Y-axis of both graphs.


G'luck.

Thanks Dave, that sounds like what I'll have to end up doing since there doesn't seem to be any type of built in functionality to do this. Simple enough!