The Graph Configuration dialog box selects the area of the cell region to act as a data source in the calculation of a graph. The geometry of the cell region will correspond to series divisions within that region and the presence of titles, series names, and/or x-axis labels. To access this dialog box, at least one graphic frame must be selected in the worksheet, then click on the last button in the fourth section of the horizontal Graphic Manipulation toolbar, or select the "Graphing tool / Configuration" entry in the menu bar.
Given the following portion of a worksheet:
Screen snap: portion of a worksheet.
To create a graph from this portion of a table, select the cell region B2:D14 as data source for the graph. In this table , the zone of values to be reported in the graph is the region C3:D14. This region must be cut into two series of 12 values: the regions C3:C14 and D3:D14. The series break is done by columns. C2 and C3 cells are series names. The B2 cell is the title or name of the graph. The cell region B3:B14 are X-axis names or titles.
Screen snap: Graph Configuration dialog box
The
Columns button indicates that the values of a data set are taken from one column.
In the example, the series must be read from one column in order to obtain a relevant
graph.
The Rows
button indicates that the values of a data set are taken from one row. In the example, the
series must be read from one row in order to obtain a relevant graph.
The X-axis labels button indicates that the first column
of the cell region contains x-axis labels. If the series are read as rows, this button
indicates that the first row contains x-axis lablels. In the example this button would be
selected. To create this graph XQuad will consider the first column to be read as the
first data set, because this column contains numbers. (Region B3:B14)
The
First Data Set button indicates that the first column of the selected cell region
contains the values for the first data set. If the series are read as rows, this button
indicates that the first row contains the values of the first data set. When this button
is selected, neither the X-axis nor the graph itself have a label.
The
Legend text button indicates that the first row of the cell region contains series
names. If the series is read in rows, this button indicates that the first column contains
series names. In the example, the first line (region C2:D2) contains the titles of two
series, therefore this button would be selected. The
First Data Set button indicates that the first row of the cell region contains the
first values of the data-set. If the series are read in rows, this button indicates that
the first column will contain the first values of the data-set. When this button is
selected, neither the series nor the graph itself have labels.
This portion contains a graphic preview with current parameters as selected in the left portion of the dialog box.
