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