Solved

Publish an Excel Spreadsheet Chart to SharePoint 2010

Posted on 2013-11-13
4
1,395 Views
Last Modified: 2013-11-26
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.
0
Comment
Question by:Lord_Dragon
  • 2
  • 2
4 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39648024
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
 

Author Comment

by:Lord_Dragon
ID: 39650971
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
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 39651050
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
 

Author Closing Comment

by:Lord_Dragon
ID: 39677641
The issue was with the chart name. The name "Chart1" needed a space added. Thanks
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question