Plot order

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top