Solved

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

Posted on 2014-09-12
2
337 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

770 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