Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,489
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I reverse name order from Last, First to First Last in Exc Annie Lord Excel Discussion (Misc queries) 4 April 22nd 23 03:10 AM
SPELL IN REVERSE ORDER John Bundy Excel Worksheet Functions 1 March 8th 07 08:19 PM
reverse order Lamb Chop Excel Discussion (Misc queries) 2 June 20th 06 04:37 PM
Allow clustered AND stacked bars on the same chart - compare valu. Dan Mazanek Charts and Charting in Excel 2 April 15th 05 01:51 AM
How 2 reverse order of columns Bill Meacham Excel Discussion (Misc queries) 3 February 20th 05 04:29 AM


All times are GMT +1. The time now is 08:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"