Change text in legend
 

I have created a chart showing two plots. In the Legend they are
labelled Series1 & Series2 by default. I have tried to rename these
using V.B. to reflect what they are showing. Can't find a away to
rename them. Can they be renamed or have I "lost the plot" It seams an
obvious requirement since Series1 & Series2 is meaningless! I am a new
at playing with charts so be gentle.

Change text in legend
 

Hi MikeR,

No sweat. Right-click on one of your "series", and select "Source Data". Now select the "Series" tab in the popup window, and voila- you can rename your series and/or fiddle with the X and Y axis values!

SuperJas.