Thanks that was easy to follow.
I added the same question today 4th May, please delete from posts.
If you did not have internet access is there a Help built into Excel, Word
etc to find out the answer to such questions?
Thanks.
Mareng

"Andy Pope" wrote:

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.