Plot order

G

Guest

I have research data entered by age groups. When the bar
chart is created the youngest is at the top. We want the
oldest group at the top.
Is there any way of changing the plotting order without
changing the spreadsheet data?
 
A

Andy Pope

Hi,

Select the axis press Ctrl+1 to display the format dialog. On the Scale
tab change the following properties;
Enable: Categories in reverse order
Enable: Value(Y) axis crosses at maximum

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non Linear Scatter plot, need to find y value 3
How to change series plotting order without changing legend order? 6
Chart Displays in reverse order 1
Plot area changed after reopen document 0
Convert Error Bars to Series and Colour 1
change chart primary horizontal axis label or name 1
Chart Plot Area changes in Excel 2007 0
Data points in chart incorrect 0

Top