AJP Excel InformationAJP Excel Information
ChartsVBAFun stuffForumsTipsLinksBooksWhat's newContactAboutSearchRSS Feed

 
 
 

Plotting bar chart categories in reverse order

 

 

 
Create a standard bar chart based on the data in A1:B6
A B
1 Rating
2 One 1.0
3 Two 2.0
4 Three 3.0
5 Four 4.0
6 Five 5.0

 

 
   
To reverse the order of the category labels so they appear in the same order as the data double click the Y (category) axis to display the Format Axis dialog
Select 'Categories in reverse order' AND 'Value (Y) axis crosses at maximum category'
 
   
 
Charting tip
   

Last updated 28th April 2007

 
 
  Home | Charts | VBA Code | Fun Stuff
Forum Examples | Tips | Links | What's New | Book List
Contact | About
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2012 Andy Pope