Office 2021: How to plot multiple Y axes in the same chart?
I couldn’t figure out how to plot multiple Y axes in the same chart.
In the screenshot below, there is a significant difference in the units, and therefore some bars fail to appear when using a single y-axis. I need to have 5 Y axes in this case.
How could this be accomplished?


The Excel file is attached.

Attached Images

Clip_220.jpg (145.0 KB, 10 views)

Attached Files

Metrics_02.xlsx (9.3 KB, 4 views)

The easiest way will be:
Instead MSE use e.g. MSE/1,000,000, and put the info about used multiplier into legend (like MSE_M)

What I need here is simply to combine these five charts into one.

Attached Images

Clip_1006.jpg (136.3 KB, 6 views)

Attached Files

Metrics_03.xlsx (25.0 KB, 3 views)

What message can you get across displaying a chart with only one value? And then have 5 of them, each representing something different. You can't make visual comparisons between them. The size of the bar means nothing. You may as well ditch the charts altogether and look at the numbers.

You're correct. There's no point or added value in presenting them in a chart. It's better if I keep them in the table; it conveys the idea more effectively.