Showing multiple charts from a single .xlsx in MOSS 2007 Excel Services - a bug in Excel

SharePoint 2007 bunch of technologies is indeed remarkable, especially on first sight. When you delve a bit deeper you can find some things to make you scratch the crown and go googling for a couple of hours but nevertheless WSS 3.0 and MOSS 2007 are really powerful.

Some of the new features that I am exploring are the basic BI capabilities that rely mainly on Excel Services. One of the components of Excel Services is the Excel Web Access web part that is capable of displaying named items from Excel 2007 worksheet, that can be:

• Pivot tables
• Charts
• Worksheets
• Named cells
• Named cell ranges

I created a workbook with 3 sheets, every one with a pivot table and a chart. I renamed the tables from the Name box (top left ), like CompaniesTable, etc. and showed them in the web parts. But when I tried to change the names of the charts they always ended up with the name 'Chart 1'.

Having all charts with the same name can make arranging the web parts in the site harder. So, here is the workaround for this Excel bug:
http://support.microsoft.com/default.aspx/kb/928984

You just rename the chart from Layout -> Chart Tools -> Properties