excel consultancy - Excel

Hi Clare

Thanks for your question.

You can change what shows in a chart legend at step 2 of the chart wizard.

1. If you go onto the Series tab, select the item showing in the legend that you wish to replace with something else, in the box headed 'Series'.

2. Then click in the Name box to the right of this, and select the cell from out of your spreadsheet that contains the correct name for the legend item.

Repeat 1 and 2 above until you have renamed each legend item.

Then click OK.

I hope this helps.
Amanda