BW Technologies GasAlertMicro 1, Руководство пользователя

Страница: 67 / 76

GasAlertMicro
E.D.M. Workbook Features and Functions
To chart a section of data, use the data filters (described
above) to restrict the data display to the section or type of
data you are interested in. Pressing the ‘Chart Data’ on
filtered data will chart only the data being displayed at that
time. This allows automatic charting of any data subset
required.
Charting: Manually charting the data
Data that is split between worksheets cannot be charted
automatically. To chart data that is split between two
worksheets, copy the data in question from the two sheets to
a new worksheet. Note that Excel has a built-in limit of
65,535 lines per worksheet.
To successfully chart the data, it is necessary to split the
‘Date & Time’ column into two columns. This is necessary
because Excel does not correctly interpret the combined date
and time.
The simplest method to do this is to make two copies of the
date & time column beside each other. Reformat column 1 to
‘Date’ using the ‘Format cells’ command, and reformat
column 2 to ‘Time’. You then may select the data you wish to
graph and use the Excel Chart Wizard to create the graph of
your choice. For more information on the Chart Wizard, refer
to Excel help.
Examples
•
To chart data over a date range: use the filter on the date
& time column to restrict the viewed data to the
appropriate range. Pressing ‘Chart Data’ will then
automatically chart the displayed data.
•
To chart data over two worksheets: Copy the required
data to a new worksheet. Copy the ‘Date & Time’ column
into two columns. Reformat column 1 as date, and
column 2 as time. Select the data to graph and press the
‘Chart Wizard’ button to graph the data.
Note: The charting process is complex and may require
some time to complete on slower machines, or if large
amounts of data is being charted. Also, Excel has a built-in
charting limit of 32,000 data points. To obtain larger graphs,
a database system such as Microsoft Access is required.
Printing: Printing the data
The workbook settings are pre-formatted to allow for easy
printing. Column headings and comments appear on each
printed sheet.
Users may, of course, customize the printout to their
individual requirements by using Excel’s built-in printing
features. Refer to the Excel help files for more information.
55