Hi,
In Excel 2010, I have a Data worksheet and a Charts worksheet. In the Charts worksheet I have hard-coded series names in the charts, while the x/y axes refer to named ranges in the Data sheet.
When there is no data in the sheet, I expect to at least see the hard-coded Series Names in the Charts, but they are blank.
Right-Clicking on the chart, and choosing "Select Data" shows "Blank Series" for all the series in the chart.
This behavior was not present in Excel 2007, but suddenly is behaving this way in Excel 2010. (The sheets are actually .xls sheets created in Excel 2003, and they must stay in that format due to user base with these three versions of Excel).
Thanks for any insight on this,
--Jim
Bookmarks