Solved

How can I reverse the order of the bar chart bars inside the chart editor

Posted on 2014-09-12
2
338 Views
Last Modified: 2014-09-12
Dear Experts,
I have to do a lot of work with bar charts and I have the following task that needs to be done often.

I have created a frequency table that lists the number of people with exams scores that have values between zero and twelve. I have arranged the cells in descending order as shown in columns A and B of the attached spreadsheet.

When I select the cells and insert a bar chart it creates a bar chart with the column for "12" on the left hand edge and the zero bar on the right.  Can I flip the order INSIDE THE CHART EDITOR so that the zero bar is on the left and the "12" bar is on the right.  I realize that I can achieve this by deleting my chart, returning to the data and then re-sorting them.

My question specifically relates to the question: "Can I reverse the order of the bars inside the chart editor".
Sincerely,
Phil
0
Comment
Question by:Philip-David Truscott
2 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40320412
Yes, if you double-click the x-axis, you should see a new dialog box titled "Format Axis".  There is an option "Categories in reverse order" that will change the displayed order.
 chart reverse axis order
Regards,
-Glenn
0
 

Author Closing Comment

by:Philip-David Truscott
ID: 40320414
Brilliant. Thanks for the quick response
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question