Forum Discussion

cswshaun's avatar
cswshaun
Copper Contributor
May 30, 2020

How to align the yaxis scale for all charts in the sheet?

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 ...
Charting
excel
Macros and VBA
cswshaun's avatar
cswshaun
Copper Contributor
Jun 02, 2020

Hi hynguyen ,

 

Thanks for the workaround.

 

Just wondering if this will work for charts refreshed by slicers? Please see attached image. I selected a few depts from the slicer but the scale of the 3 charts are not aligned.

Thank you!

hynguyen's avatar
hynguyen
Iron Contributor
Jun 02, 2020

cswshaun If you also select the first "empty space" dept, it would work because it helps scale all charts to the same upper bound.

Resources