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

X

xxu8810152

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!
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top