Excel charts and updating data Canadian sexy college girls webcam
These methods will make it quick to update an old chart rather than re-creating a new chart. This is very handy if you want to show a rolling six months of data. You will see a blue outline appear around the chart data in the worksheet as shown in Figure 1.
If you have already created a chart in Excel, you can embed and link it to your Power Point presentation.
Note that the Excel Web Access web part that Peter uses in the demo is only available in the Enterprise Plan of Share Point or Office 365.
When an Excel chart is added to a Share Point page in this way, it will not be updated automatically when the list data is changed.
Editor’s Note: To read more about spreadsheets, share a tip with other readers, or suggest a topic for Bill Jelen to cover in an upcoming column, click here to visit CFO.com’s Spreadsheet Tips page.
Your department probably is responsible for producing a dozen or so monthly trend charts every month.
However, Peter describes the VB script method for Excel chart auto-refresh in detail in the next article.