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

1. Right-click in any data cell and click Data Range Properties in the shortcut menu that appears.
Figure 41 Data Range Properties Shortcut Menu
The External Data Range Properties dialog box appears.
2. Select the Refresh every checkbox and enter the desired value.
Figure 42 External Data Range Properties Dialog Box
3. Click OK.
Retaining Charts
The HP 3PAR System Reporter Excel client workbook is designed to reuse data sheets, redrawing
charts on the reporting tool sheets with updated data or modified query parameters as required.
To redraw a chart on a reporting tools sheet with updated data or modified query parameters,
use the reporting tool sheet controls to make any changes and then click Refresh. The values on
the corresponding data sheet are updated and the charts on the reporting tool sheet are redrawn.
102 Accessing and Creating Reports