#1
|
|||
|
|||
Office 2021: How to plot multiple Y axes in the same chart?
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.
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
What I need here is simply to combine these five charts into one.
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#4
|
||||
|
||||
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.
|
#5
|
|||
|
|||
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.
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office 2021: How to create grouped bar chart of three columns? | Jamal NUMAN | Excel | 6 | 02-16-2024 11:20 AM |
How to make scatter plot chart of data with labels in horizontal axis? | soroush.kalantari | Excel | 2 | 01-28-2024 08:16 PM |
Transition from Office 365 to Office Pro 2021 | PHearn | Outlook | 0 | 06-08-2022 07:01 PM |
Office 2021 for Mac | NeilC | Office | 3 | 10-14-2021 01:50 AM |
Chart with both y-axes used - include more? | Officer_Bierschnitt | Excel | 5 | 10-27-2015 06:18 AM |