Hi,
Select the chart and use the ribbon
Chart Tools Design Data Select Data
On the dialog select the appropriate series and Edit.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mareng" wrote in message
...
I wish to change the text in the legend box from say- (Series 1) to (MPG)
or
anything that has a relevance to the graph. This was done easily in Works
Spreadsheet and previous versions of Excel.
Using 2007 Student & Home version.