Automatic updating excel chart
When Q exports a table or chart to Power Point and Excel it scans the documents to see if the code is contained within the document and, if it is found, the option of updating is provided.
By following " i can get a chart automatically updating down a column but i need it to update as the relevent information jumps across 3 columns along a given row.
While you can certainly copy and paste data from a network or Web-based external source into Excel, importing the data by connecting to it provides an added benefit.
If the information in the primary source should change, you can simply refresh your worksheet to update your data as well.
Graph 1 needs to display the most recent information (ie the thickness at the most resent available date) and the second graph needs to add another value each time more information is added to the form.
Is there a way to create a chart/graph from a Sharepoint list, whether through Sharepoint graphing or MS Excel, so that the chart will automatically update when the data in the list changes?
Search for automatic updating excel chart:
Every table and chart which appears in the Report tree contains an invisible code.