displaying an excel chart in sharepoint 2007 in SharePoint Server Design and Customization    |   |  Help   Search For:     In:   Office   SharePoint Portal Server     SharePoint Server General Q&A and Discussions     SharePoint Server Design and Customization     SharePoint Server Setup and Administration     SharePoint Server Development and Programming              tinil 4/27/2007 12:24 AM PST   Question   hi, i have created an excel graph based on a table. i would like to get it displayed in our team site(sharepoint based). i hve to update the data source (the table) once in everymonth and i would like to get the graph automatically updated . so may b graph in share point site - linked to my source table. pls advice me how to do this or if u can suggest a better way of doing so. thanks tinil.     Was this post helpful to you?         Reply |   Top           Tom Simonds 4/27/2007 6:36 AM PST   Answer   If you have Office 2007 then the Excel spreadsheet can be displayed on a web page using an Excel Web Access web part . You need to store the Excel document in a 'Trusted location' (Central Administration - Shared Services Administration - Trusted File Locations) "tinil" wrote: > hi, > i have created an excel graph based on a table. i would like to get it > displayed in our team site(sharepoint based). i hve to update the data source > (the table) once in everymonth and i would like to get the graph > automatically updated . so may b graph in share point site - linked to my > source table. > pls advice me how to do this or if u can suggest a better way of doing so. > > thanks > tinil.     Was this post helpful to you?         Reply |   Top           Dean 5/22/2007 5:37 AM PST   If you have Excel 2003, or an earlier version, you can File, Save As Web Page, click Add Interactivity, choose the ranges, sheets you want to publish, check AutoUpdate and whenever the Excel file gets opened and changed, the updates will change the HTML page. Save the HTML in a doc library in SharePoint, then use a Web Part page with the Page Viewer web part to display the Excel chart. "tinil" <tinil@discussions.microsoft.com> wrote in message news:F54498D1-3D52-4447-A6BE-2807A20C28ED@microsoft.com... > hi, > i have created an excel graph based on a table. i would like to get it > displayed in our team site(sharepoint based). i hve to update the data > source > (the table) once in everymonth and i would like to get the graph > automatically updated . so may b graph in share point site - linked to my > source table. > pls advice me how to do this or if u can suggest a better way of doing so. > > thanks > tinil.     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies