Publish a graph/chart created in MS Excel onto your SharePoint Site

Create your graph/chart using Microsoft Excel:

 

Upload your Microsoft Excel document into a sharepoint document list:

 

Select your graph/chart by clicking on it, and press the save as web page menu item:

 

 

Before saving, select the "publish/Republish" radio button, set your title and file name:

 

 

Configure your publishing settings, by pressing the tools menu item in the upper right hand corner of the dialog:

 

I've found that selecting "Allow PNG as a graphics format" will improve image quality, but you should configure your settings based upon your needs:

 

Press the publish button.  Make sure you have the "AutoRepublish..." checkbox selected if you want your chart to be updated everytime the Microsoft Excel document is updated.

 

Once published, you will see your chart saved off as a web page in your document list:

 

 Go to the location on your sharepoint site where you want the graph to appear and modify the site content... then and add a "Page Viewer Web Part" to your site:

 

Drag this onto the desired location on your site:

 

Open the tool pane for this web part and setup the web page reference (take the url of you publish graph/chart webpage):

 

Your graph/chart should be visible on your site... and will resynchronize itself every time the document is updated!

 

 

Team VivaBig (Inetium's SMS&P, Application Development Team)


Posted 10-11-2006 1:54 PM by jvogt

Comments

Rachel Garrett wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 05-29-2008 10:45 AM

Thank you -- this is EXACTLY what I needed. I had many of the steps in place, but I was not aware of the possibility of using the Page Viewer Web Part to see pages I'd published from Excel to SharePoint. This solves 2 problems I was working on and 1 that I wasn't.

Rob T wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 07-17-2008 8:48 PM

This is a fantastic solution to an problem that we've been dealing with.

Nicely done - thank you!

Diana wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 08-21-2008 2:29 PM

Thanks for the directions! this is what i needed to know in order for us to post our monthly metric charts. we had been recreating them and posting as images. this saves us a couple man(woman)hours each month!

Kendall Beach wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 09-16-2008 3:30 PM

This was extremely helpful.  Wanted to know if there was a way to have the graphs tie directly to an excel spreadsheet so that when the spreadsheet is updated, the graphs automatically update.

How do you link excel with Sharepoint? | All about Sharepoint wrote How do you link excel with Sharepoint? | All about Sharepoint
on 10-28-2008 11:44 PM

Pingback from  How do you link excel with Sharepoint? | All about Sharepoint

Hanne Jeppesen wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 11-04-2008 10:59 AM

I have used this quite a bit on our SharePoint site; problems is we have now upgraded to Excel 2007 and cannot get it to publish only the Chart and not the whole work book. Any ides on how to resolve this problem?

Larry Bradshaw wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 11-05-2008 12:02 PM

I can't seem to get it to adjust the size of image, the images it publishes are too big. I've selected a smaller size in the web properties but still always publishes at a large size.

Anon wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 11-05-2008 12:07 PM

You have to resize the Chart in the Excel workbook.

Anon wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 01-22-2009 4:26 AM

Ty for this tutorial it enabled me to achieve what i needed.

@ Hanne Jeppesen - You can move the chart to a separate Sheet, this worked for me.

Sue wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 02-11-2009 11:04 AM

Hello,

I have a SharePoint survey which links to an excel spreadheet. I am able to sychronize the excel sheet with the survey results, graph these results in excel and publish them to my SharePoint site. Does anyone know if there is a more dynamic way to do this..so that I could have my published graphs update automatically on SharePoint everytime someone takes the survey..without having to lauch excel, synchronize the excel sheet with SharePoint and have it automatically republish the graphs.

I have played around with Macros in excel, Scheduled tasks on the server to attempt to accomplish this, but I was wondering if there was a more direct way.

Thanks for any ideas.

Kanwal wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 02-18-2009 11:54 AM

Nice job , really well laid out instructions that work . Saved me hours.  Thankyou.

sarangasl wrote re: Publish a graph/chart created in MS Excel onto your SharePoint Site
on 11-13-2009 12:04 PM
Inetium, LLC. Site Information