Copying information from a histogram to the Clipboard
You can copy information from a histogram graph to the Clipboard. You may want to do this in order to paste the histogram information into an external program, for example a spreadsheet, for subsequent manipulation.
If you have more than one graph displayed in a histogram, you can only copy information from a single graph at a time. Which graph you copy from depends on the graph you click on when selecting the Copy command.
The information you copy to the Clipboard is in the form of columns of figures. The example below shows a simple allocation graph for a resource:
|
04/08/20 00:00 |
0.00 |
|
11/08/20 00:00 |
0.00 |
|
18/08/20 00:00 |
1.00 |
|
25/08/20 00:00 |
3.00 |
|
01/09/20 00:00 |
2.00 |
|
08/09/20 00:00 |
1.00 |
The columns in the above example contain the following information:
- The date and time of the selected slicing time unit (or Clipboard unit if a slicing time unit is not specified). In the above example, the slicing time unit is set to elapsed weeks and the times all show midnight (00:00); if it was set to days, there would be a row for each day rather than for each week. If you do not select a slicing time unit or a Clipboard time unit, there will be a row of information for each node in the graph.
- The point on the y-axis at which the histogram graph displays a value during this slicing time period. In the above example, the resource is not allocated in the first two weeks, and has varying allocation in the last four weeks. You can specify the value that is returned in each period using the Type field in the Slicing group on the Report tab of the Histogram Report Properties dialog.
To copy information from a histogram graph to the Clipboard, right-click the histogram graph you want to copy and select Copy <graph name>.
Specifying precisely the values and dates that are copied
When you copy information from a sliced histogram graph to the Clipboard, the data is divided into equal time periods, as specified by the slicing time unit, or the Clipboard unit if one is not specified.
You can specify the value that is copied for each time period as follows:
- If the graph is sliced, the selected slice type is used to calculate the value that is copied (for example, the maximum, minimum or average value in each period).
- If the graph is not sliced, the value at the end of the time period is copied in the case of cumulative graphs.
- If the graph is not sliced, the average value is copied in the case of non-cumulative graphs, unless you press SHIFT while right-clicking the histogram graph and selecting Copy <graph name>, in which case the peak value is copied.
You can specify the date that is copied for each time period as follows:
- Press and hold down CTRL while right-clicking the histogram graph and selecting Copy <graph name> to copy the start date of each time period.
- Right-click the histogram graph and select Copy <graph name> without pressing and holding down CTRL to copy the start date of the previous time period.
Note that you must right-click the histogram graph precisely on part of the graph in order for this command to be available: if you right-click a blank area of the histogram, the command does not appear. Alternatively, right-click the legend of the histogram graph if one is displayed.
You can then paste the information into another application.
The values in the above example would be displayed as follows in a histogram:
