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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Shyamal" wrote in message
...
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