This updating mechanism is relatively robust and can be used to update a document from multiple Q projects and also to update multiple different documents from a single Q project.We all know that to make a chart we must specify a range of values as input.
Lets assume the data table is in the cell range: $F: $G Ok, the problem is that as and when we add a row at the end (or remove a row), we should update the chart’s data range. A refresher on how to use OFFSET formula: Create a new named range and in the “refers to:” input box, type the OFFSET formula that would generate a dynamic range of values based on no. For the source data use the named ranges we have just created.Important: You must use the named range along with worksheet name, otherwise excel wont accept the named range for chart source data.When charts and tables are exported form Q to Power Point this invisible code is hidden in the exported objects.When Q exports a table or plot 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.I put a Chart and a view of the List together on a Web Part Page, so that editing an item in the list web part will cause the browser to reload the page, thus updating the chart image.
The only downside is that you have to specify the chart's image dimensions at design time, so it won't easily scale for a wide range of screen resolutions.
Would you like to answer one of these unanswered questions instead?
If you attempt to export to an Excel or Power Point document into which you have previously exported, a dialog box will appear saying You have already exported this project to Presentation Name, which is open.
The Chart Web Part also offers you the choice between connecting directly to the actual list, or connecting to the list web part that you've put on the page.
If you connect to the web part, then you get the added benefit of a dynamic chart - filtering the list in the web part instantly filters the chart to the same data, but the drawback is that the chart's axes can only be linked to columns actually displayed in that view (connecting to the actual list lets you use any column for your axes).
Click here to download the dynamic chart ranges workbook and use it to learn this trick.