There is a bug in Excel 2007 Beta 2. In the legend for the chart if the
Series Name value is set equal to a cell and that cell is hidden then the
Series Name value is not reported correctly. It shows in my case as Series2.
If I unhide the column containing the cell the correct Series Name value
appears. I can then hide the cell/column again and the chart shows the
correct value. After saving the file and opening it again the legend will
again show the incorrect value "Series2".

This spreadsheet was created in Excel03 originally.
--
Regards,
James M

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting