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).You can specify the value that is copied for each time period as follows: When you copy information from a sliced histogram graph to Excel, the data is divided into equal time periods, as specified by the slicing time unit, or the Clipboard unit if one is not specified. If you do not select a slicing time unit, there will be a row of information for each node in the graph. Data from the selected graph(s) is exported into the subsequent columns, and represent measurements that correspond to the time values in the first column. The first column represents the date and time of the selected slicing time unit. The information is copied into the first available data sheet in the selected file. Click OK to export the information from the histogram graphs into Excel.The Histogram Export dialog appears.ĭo not right-click the histogram row over part of one of its graphs: if you right-click one of the graphs, the Export to Excel command appears instead, which you use to copy information from a specific graph in the histogram to Excel. Right-click the histogram row you want to export and select Export to Excel.Click OK to export the information from the histogram graph into Excel.If no templates are displayed, or if the template you require is not displayed, click Look in and browse for the folder containing the template you want.Note that any data that is contained within the selected template is disregarded. This field displays the Excel templates that are located in the folder specified on the File Locations tab of the XLS file in the Select an export template field.
Select an Excel template with which to create the.Alternatively, click Browse to search for the location of the file you want to create. If you enter the name of an existing file, you are asked whether you want to overwrite the file or not. You can enter the name of a new file, or an existing one. XLS file to which you want to export the information in the Export file name field. 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 Export to Excel command appears instead, which you use to copy information from all of the graphs in the histogram to Excel.
0 kommentar(er)
