in

Justin Vogt

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)

Only published comments... Oct 11 2006, 01:54 PM by jvogt

Comments

 

Rachel Garrett said:

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.

May 29, 2008 10:45 AM
 

Rob T said:

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

Nicely done - thank you!

July 17, 2008 8:48 PM
 

Diana said:

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!

August 21, 2008 2:29 PM
 

Kendall Beach said:

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.

September 16, 2008 3:30 PM
 

How do you link excel with Sharepoint? | All about Sharepoint said:

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

October 28, 2008 11:44 PM
 

Hanne Jeppesen said:

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?

November 4, 2008 10:59 AM
 

Larry Bradshaw said:

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.

November 5, 2008 12:02 PM
 

Anon said:

You have to resize the Chart in the Excel workbook.

November 5, 2008 12:07 PM

Leave a Comment

(required)  
(optional)
(required)  
Add
Inetium, LLC. Disclaimer