Hi All,
Please see my sample workbook. I have a few pivot charts in a worksheet.
Currently, it is hard to compare the charts as their Y-AXIS scale is different. I would like to align the scale of all charts in the worksheet based on the maximum scale in all charts.
For example, when all depts are selected, the maximum scale is 600 (chart 1), hence the scale for chart 2 and 3 to be set as 600 too.
For example, if dept AZ is selected in slicer, the maximum scale of the 3 charts is 3.5 (chart 1), hence the scale for chart 2 and 3 to be set as 3.5 too.
Appreciate the advice
Thanks!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!