HP 3PAR System Reporter Software - Manual (Page 146)

5.54 Working with Excel Charts
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.
1 Right-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.