How to reverse the order of bars in Bar Clustered chart?
 

Hello,

I have a question about plotting in Bar Clustered. Say I have two
cells like
A1 = 5
A2 = 10

When I use Bar Clustered to plot it, it puts the 10 above the 5, like
**********
*****
(Assuming the asterisks represent the length of the bar.) So it
reversed the oder of two cells.
Actually I would like Excel to plot it like
*****
**********

Does anyone know how to do it?

Thanks!

How to reverse the order of bars in Bar Clustered chart?
 

Hi,

Double click the category axis (Y) and on the scale tab check both
- Categories in reverse order
- Value (Y) axis crosses at maximum category

This will flip the order of categories and keep the value axis at the
bottom.

Cheers
Andy

wrote:
Hello,

I have a question about plotting in Bar Clustered. Say I have two
cells like
A1 = 5
A2 = 10

When I use Bar Clustered to plot it, it puts the 10 above the 5, like
**********
*****
(Assuming the asterisks represent the length of the bar.) So it
reversed the oder of two cells.
Actually I would like Excel to plot it like
*****
**********

Does anyone know how to do it?

Thanks!