How to define a common scale for primary and secondary Y-axis?
I have a (stacked) bar chart with two measures - one measure on the primary Y-axis, the other on the secondary y-axis. As these two measures should be comparable (imagine e.g. incoming vs. handled service requests) I want to assure that the Y-axises' scales are always identical, but of course not fixed to a certain maximum value!
With trellised charts I could use the axis option "Common scale". Is there something similar for the primary and the secondary Y-axis?
4 replies
-
Hi
You don't need a secondary axis for it, you need to use the primary axis for both measures.
When you drag the second measure to the values, select primary axis, and choose the bar chart under the first measure.
Let me know if you found it,
-
, thanks for your answer!
First of all, apologies for being imprecise: I would like to have (stacked) column charts - not bar charts!
And, you are right: With a bar chart and actually with a column chart as well (I haven't seen this before) it's possible to display two measures one below the other or side by side respectively - both on the primary axis.
But when it comes to stacked bar charts or stacked column charts this obviously does not work. The measures will not be displayed one below the other or side by side, respectively.
And, finally: It obviously is not possible to define a common scale for the primary and the secondary Y-axis, right?
-
-
Hi
You are correct. However there is a workaround whereby we show the stacked measures and single measures together on the primary axis. In fact, I provided an answer to the same problem previously.
See https://community.pyramidanalytics.com/t/x2hph3y/stacked-and-non-stacked-chart-together for the solution.
Hope that helps.
Ian