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
 
You must log in or register to reply here.

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

How to change series plotting order without changing legend order? 6
Chart Displays in reverse order 1
Convert Error Bars to Series and Colour 1
adding trendline to plots from multiple series 1
plot area inconsistent sizes with VBA 2
Surpressing plot of blank cells 3
Plot value at top of chart 1
Bar and Line plots on the same chart 2

Back
Top