[SOLVED] Chart Legend

Wheelz · Posted: Mon Dec 20, 2010 11:48 pm Post subject: [SOLVED] Chart Legend

Hi,

I'm struggling to find out how to edit the legend labels other than font, colour, border etc.

They've come up as "1" and "2" but I want to be able to name them "Paid" and "Balance".

Could someone please steer me in the right direction?

Thanks.
Pete

_________________
http://www.tsw.net.nz/ladder.htm

keme · Posted: Tue Dec 21, 2010 12:40 am Post subject:

Double click your chart to enter chart edit mode (gray border and small black handles, like in your image).
Right click the chart, and select Data ranges...
- In the Data range tab, include the table header in the given range, and tick First row as label,
  ...or...
- In the Data series tab, enter the range for data labels in the Categories field.

Wheelz · Posted: Tue Dec 21, 2010 12:47 am Post subject:

That was so easy and so obvious (in hind sight).
How embarrassing.

Thanks Keme.
_________________
http://www.tsw.net.nz/ladder.htm