nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can y-axis scale be kept constant?

mmr11408

I have a report with a legend that allows the user to select each item (day of the week) from the legend to show or hide it (see the attached picture). The scale changes when days with high value are shown or hidden. For example, when Friday and Tuesday are hidden, the y-axis scale changes from 1,000,000 to 800,000. This is confusing for the user. Is there a way to force that to be fixed?

Find more posts tagged with

Comments

pricher

Hi,
 
In the Chart Wizard, go to Format Chart --> Y-Axis --> Scale. Turn off the Auto setting for Min and Max and enter your own Min and Max values, as shown here:

mmr11408

Thanks, worked like a charm. BTW, congratulations to everyone involved with the product, I find it extremely useful.