Publish an Excel Spreadsheet Chart to SharePoint 2010

I have an Excel Spreadsheet that contains a Chart named "Chart 1".  I published this Excel chart to a Sharepoint site home page and it has been functioning well up until now.

A colleague recently made some updates to the Excel spreadsheet and inadvertanly did something to break the connection between the Excel spreadsheet Chart and Sharepoint.

When I try to Publish the Chart to Sharepoint now, I get the error "Failed to download Chart or image".

I've followed the steps diligently and I've done this before successfully but now it will not connect. There is a table in the same Excel spreadsheet that I also published to the same SharePoint page and it is functioning properly.

Any insight on how to resolve this would be greatly appreciated.
Lord_DragonAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rainer JeschorConnect With a Mentor Commented:
Hi,
hm. OK.
There are two options:
either Excel Service has an issue OR the chart itself is not compatible.

Can you have a look into the SharePoint ULS logs?
Have you already tried to restart Excel Services?
Do you have another SharePoint farm to test it in a different environment?

I had once an issue which could only be solved by increasing the RAM for that virtualized SharePoint (8 -> 12 GB).

HTH
Rainer
0
 
Rainer JeschorCommented:
Hi,
could you please explain what you mean with "Publish chart"?

Do you upload the Excel file to a SharePoint library and use an Excel Web Part to display the chart on the site (using Excel Services)?
If yes, I would double check if:
- The chart has a name?
- In the Publish to Excel Services the named chart is selected (Publish -> Excel Services -> Excel Services Options -> Tab "Show" -> your named chart is selected

HTH
Rainer
0
 
Lord_DragonAuthor Commented:
Yes, those are the steps that I used to publish the chart and yes the chart has a name, it is chart1. I believe the fact that the error message reads "Failed to download Chart or image" implies that the chart is being accessed but not rendered.
0
 
Lord_DragonAuthor Commented:
The issue was with the chart name. The name "Chart1" needed a space added. Thanks
0
All Courses

From novice to tech pro — start learning today.