09-28-2022 12:15 PM
I have a bar and line chart (line being the 2nd Y-Axis). I want to sync the two scales; Anyone know how to do that? I did not see an option to sync and looking for guidance.
Solved! Go to Solution.
09-29-2022 11:04 AM
The secondary axis is meant to highlight similar trends on a different scale, not to replicate the original one. If you want both datasets on the same scale, just deselect the "Plot on secondary axis" option and they should "merge" on the same scale on the left.
Open the options for the dataset currently plotted on the right axis:
Then deselect the option and click Ok:
Hope that helps!
09-29-2022 05:25 AM
Hi Sarah, I'm not sure I understand what you mean by "sync". Can you post a few screenshots of your settings and outcomes, to clarify...?
09-29-2022 10:18 AM
Hello Jack. I am just trying to get the same scale on the both of the Y axis. The black line is similar to a budget. It looks like the sales are below budget based on the graph, but there a few periods that are above budget. If I can get them on the same scale then the black line would move down and thus the pic would show some periods above budget. does that make sense?
09-29-2022 11:04 AM
The secondary axis is meant to highlight similar trends on a different scale, not to replicate the original one. If you want both datasets on the same scale, just deselect the "Plot on secondary axis" option and they should "merge" on the same scale on the left.
Open the options for the dataset currently plotted on the right axis:
Then deselect the option and click Ok:
Hope that helps!
09-29-2022 11:37 AM
Thank you. That is what I needed. I thought I needed to plot it as a second axis (had to do that on other BI applications). I worked just as you said. Greatly appreciate the help!