Share this content
0
3
1325

Excel Charts

Hello,

I am preparing charts for an AGM.

The first one is to show Total Funds over the last 4 years.

I have the EXcel sheet with the year (formatted) in on row, and the Total Funds in the row beneath.

When I convert to a chart, the years are reversed, so that 2012 appears last, instead of first.

Can anytone help on this please.

Many thanks,

Rosemary

Replies

Please login or register to join the discussion.

avatar
By neileg
31st Dec 2012 14:38

That's the default plotting order

If you want to reverse the order, right click the X axis, Format Axis, Scale, check Categories in reverse order.

At least that's what you do in Excel 2003!

Thanks (0)
avatar
By Optegra
01st Jan 2013 12:20

Move legend

Hi

If you are using excel 2007 + then right click on the chart and press "select data source"

Select the relevant legend entry in the box on the left hand side and change the order by clicking on the small arrow next to the remove box.

Hope that helps

Thanks

Jeremy

Thanks (0)
avatar
By sdataw
18th Jan 2013 17:09

reverse chart

Are you sorted with help from PM and Jermy?

If not, when you are selecting what to chart start with the rows and columns taht represent the earlier years first.

Regards

Thanks (0)