Nov 30 2021 02:27 AM
Hi everyone
I wonder if someone can help with this challenge that has bugged me for a long time. I make a lot of bar charts in Excel. However, when I set up the data in a spreadsheet, the order of the categories is always reversed in the bar chart. You can see this in the screenshot.
Can anyone tell me how to avoid this?
Thank you!
Kevin
Nov 30 2021 02:44 AM
@Kevin_Burchell Format the vertical axis to show categories in reverse order, and the set the horizontal axis labels position to be "high".
Attached an example.
Nov 30 2021 03:02 AM
Nov 30 2021 03:19 AM
@Kevin_Burchell Bar charts are a bit special. If you have series/categories A,B and C, the chart displays them C,B,A from the top down. Hence you have to reverse the order.
But perhaps now I have lost you. Can upload some examples explaining the problem(s)
Nov 30 2021 05:14 AM