Thread: Scaling for charts issue

I have a set of charts that I refresh daily. Each chart is a line chart comparing two variables, where number change quite a lot.

I would like to make every chart on the page have the same scale, so that they are immediately visually comparable, but the problem is that the maximum and minimums of each chart could be quite diffferent and change daily (e.g one day the max of all the charts may be 100%, other times 10%).

I would prefer not to have to manually look at the max/min each day and set the ranges on each chart manually, but rather to have the scale look at two cells, which have the min/max required for that day. As far as I can make out it is not possible to link the scale ranges to a cell (in teh same way that it is possible for chart title for example).....am I wrong or is there a way around this??

Thanks
Will

Either use code, for full control, to set the scales for all the charts, there are previous posts on this topic.

For a non vba solution add an extra series to each chart that contains the min and max value for all the data series. The scale will then auto size to the same values.