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

5.57 Working with Excel Charts
System Reporter 2.8 3PAR System Reporter User’s Guide
1 Click on the appropriate tab at the bottom of the screen to access the report you want to
save as an executable file.
2 Click on the Windows Office Button in the upper right corner.
3 Choose Save As, then select Microsoft Office Excel Workbook (for Excel 2007, you also
have the option of saving as (Excel Macro Enabled Workbook).
4 Assign a name to the file and click Save.
5.4.5 Customizing Excel Reports
Read this section for information on customizing the charts used to plot the results of database
queries initiated with the 3PAR System Reporter Excel client.
To customize a chart, you must edit the data sheet associated with that chart. Customized
charts typically make use of custom columns added to a data sheet.
5.4.5.1 Adding Custom Columns to a Data Sheet
The following instructions illustrate how to add custom columns to a data sheet. In this
example, you will add the custom columns Non-failed spare and Percent spare used to
the Dly PDSpace (1) sheet. In the following section, Creating a Custom Chart on page 5.58,
you will create a custom chart using one of these new columns.
To add custom columns to the Dly PDSpace (1) sheet:
1 On the PD Space reporting tool sheet, create a chart with data that spans any time range.
NOTE: The Visual Basic code for the Excel client is password protected to prevent
accidental modification. For customers who would like to add their own code, the
password is “password”. Please observe caution when considering using another
password other than the default, since subsequent access would not be possible if
knowledge of the altered password were to become unavailable for some reason.
NOTE: User defined columns can only be added as the last column in the data
sheet.