HP 3PAR StoreServ 7000 Storage - Manual (Page 101)

It is also possible to retain a chart for further reference. This can be done by moving the chart and
the data sheet linked to that chart to new worksheets. See the instructions that follow for a detailed
description of how to complete this procedure.
To retain a chart for further reference
1.
On the chart to be retained, right-click to bring up the shortcut menu.
2. On the shortcut menu, click Location (for Excel 2003) or Move Chart (for Excel 2007).
The Chart Location (for Excel 2003) or Move Chart (for Excel 2007) dialog appears.
3. In the Chart Location or Move Chart dialog box, click As new sheet or New sheet and then
click OK to move the chart to a new sheet.
A new tab (with the specified name) appears at the bottom of the window for the new worksheet
that holds the moved chart.
NOTE: Moving a chart may cause it to be resized. When a chart becomes smaller, you can
adjust the axis labels to make them more readable. To adjust the axis, right-click the axis,
click Format Axis... on the shortcut menu that appears, and then use the controls in the Format
Axis dialog box.
4. Identify the data sheet that contains the source data for the moved chart. For example, a chart
generated with the PDIO reporting tool sheet is linked to data on either the PDSpace Time Data
or PDSpace Items Data sheet.
NOTE: If you don’t know the name of the data sheet that holds the source data for a chart,
you can right-click the chart and click Source Data..., then click the Series tab in the Source
Data dialog box that appears. On the Series tab, look at the Name and Values boxes. The
worksheet name appears in both boxes, just before the exclamation point.
5. Right-click the source data sheet tab and click Rename, then edit the data sheet name. Be sure
to use a unique name that is not used for any other reporting tool or data sheets in the Excel
client workbook.
After editing the data sheet name, you can return to the reporting tool sheet to perform
additional queries without affecting the relocated chart or the data sheet holding its source
data.
Exporting Executable Reports
When working with reports generated through the Excel client, you have the ability to save the
contents to a file where the formatted data can be accessed. This is useful when you want to have
data in a given report accessible to anyone in a directory or to email the reports. Here are the
steps for saving an executable report:
1.
Click the appropriate tab at the bottom of the screen to access the report you want to save as
an executable file.
2. Click 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.
Customizing Excel Reports
Read this section for information on customizing the charts used to plot the results of database
queries initiated with the HP 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.
Working with Excel Charts 101