How can I reverse the order of the bar chart bars inside the chart editor
Posted on 2014-09-12
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".