3PAR System Reporter User’s Guide

System Reporter 2.8

Using another option provided through Excel, you can have the data refreshed according to a specific schedule by modifying the properties of query table from which the charting information is derived. When the table data is refreshed, any charts based on the table will also be refreshed. Setting a table to be automatically refreshed is most applicable with a table that was created using relative time selections. Here are the steps for modifying the query table to refresh the data according to a given schedule.

1Right-click in any data cell and click Data Range Properties in the shortcut menu that appears.

Figure 5-19.Data Range Properties Shortcut Menu

The External Data Range Properties dialog box appears.

2 Select the Refresh every checkbox and enter the desired value.

5.54

Working with Excel Charts