Need to set left and right Y Axis' to different ranges

[Crystole Roberts]

Hello,

I am trying to create a full-stacked column chart, where I show the individual proportions for each arguement. In this case, I am displaying the % of employees, but want to display the Total Employees for each arguement as well. I imagined I could do this by adding an additional series to the chart (Stacked Line- was the only reasonable option), and setting the Y Axis to the Right Y Axis in section 3. Behavior. I expected to be able to set the range for the right Y Axis to something different than the left Y Axis, but there is no where to set the range for the right Y axis; and, if I set the left Y Axis to a max of 100 (100%), the right Y Axis prints with a range of 0 to 100, which does not contain the chart data. Is there a workaround for me?

Thanks!
Crystole Roberts

[Alex K.]

Hello,

Maybe we did not exactly understand your problem. Can you send us a data sample for this task and a screenshot how this should look like.

Thank you.