Being new to SharePoint 2010, I've read online some instructions on how to display an Excel chart/graph on a wiki page library, and after following the instructions, the only thing that shows on the page is a square with a red 'x' in the box. My PC has Windows 7 and Office 2010 installed.
I saved the Excel file with a '.xlsx' extension and then uploaded it into the Shared Documents library of my site. Then, I opened up the wiki page library and clicked on the Insert tab, then selected Picture, From Address. The path I used was: http://serversp/MyDept/_vti_bin/ExcelRest.aspx/Shared%20Documents/Book1.xls/Models/Charts('Sheet1')
I verifed that Excel Services was activated under Site Settings, but I'm not sure how to resolve this issue as I have lots of charts/graphs that I want to display in real time to other users.
Anyone have any solutions to this is ongoing dilemma is welcomed to reply.
Thanks!
I'll have somebody get back to you.
Thank you
Brian
Have you tried running http://serversp/MyDept/_vti_bin/ListData.svc?
If you receive an error from that address you might want to look into installing the Data Services Update for .NET 3.5 SP1. You can find more information about it at blogs.msdn.com. Some SharePoint users have found this to resolve issues with REST.
If ListData.svc is functioning properly, my next step would be to recommend you try running http://serversp/MyDept/_vti_bin/ExcelRest.aspx/Shared%20Documents/Book1.xls/Model/
If this link doesn't render I would review the link. Is the document spelled correctly and do you have the correct extension?
If it does render you should be able to navigate to the available references in your document. Click on Charts to see the names of the available charts.
If Charts is not an option, or Charts does not return a list of available charts, I would recommend reviewing the contents of your spreadsheet.
In Office 2010 you should be able to identify or change the name of a chart by selecting the chart and navigating to the Chart Tools Ribbon, Layout. In the Layout Ribbon the Chart Name can be viewed and edited in the Properties group.
I hope this helps.
Thanks,
Brad
Hi Brad,
I received an error message when I tried to run the first link in your post, so I'm having to download the Data Serivces update and then try the link again. I'll reply back to this forum post to let you know how it went.
I appreciate your help!
Steve
I was able to successfully run the first link...it returned a screen with XML data on it for the MyDept site....but when I tried to run the link with the 'excelrest.aspx', the screen was blank and displayed 'Done' in the bottom left corner...
I tred using a second spreadsheet....I uploaded the 'xlsx' file into the Shared Documents Library (it has the data on 'sheet3' and the five charts displayed on the 2nd sheet (Charts)...I clicked on Insert/Picture - from address, entered the URL, and it still displayed the red 'x' in the box.
Hi Steve,Try building the URL in the browser first. A successful URL should display the chart or REST data on the page by itself. The 4XX error you receive might help you locate your issue as well.A 404 error will tend to indicate a problem with the address to the file. A 400 error will usually be an issue with the command.If the file you uploaded is indeed an xlsx file the original link you provided is referencing an xls file which would probably return a 400 error. The original link your provided will also return a 400 error due to the "s" in Models.
Try building the URL in the browser before using it as a reference within SharePoint. See if that helps at all.