| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reverse name order from Last, First to First Last in Exc | Excel Discussion (Misc queries) | |||
| SPELL IN REVERSE ORDER | Excel Worksheet Functions | |||
| reverse order | Excel Discussion (Misc queries) | |||
| Allow clustered AND stacked bars on the same chart - compare valu. | Charts and Charting in Excel | |||
| How 2 reverse order of columns | Excel Discussion (Misc queries) | |||
Linear Mode
