Standardize the y axis

S

Shyamal

I have created a dashboard that plots the top 5 cost drivers for the time
period, for the data set that I am analyzing. However the maximum value of
the cost drivers in all the time period differ greatly. How am I able to
relate all the graphs on the page together so they share a common y axis
range?

Thank you
 
A

Andy Pope

Hi,

Depending on the chart style you have chosen you could use a dummy data
series that contains the min and max values for all the data displayed.
This would force the Auto scaling to produce the same range for each chart.

Or you could use code. Check the min and max scale values for all the charts
and then apply that to each chart.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top