Help for Drawing Graph

The QESS can draw the following graphs.

Line chart, Stacked bar chart, Grouped bar chart, Pie chart, Scatter chart, Radar chart, Bubble chart、and Candlestick chart.

1. Put source data into cells. One column means one data set. One row means one entry of the data set. In the following example, 4 entries (A,B,C,D) are included in each of 3 data set (X,Y,Z).

   Test	X	Y	Z
   A	1	16	0.5
   B	2	12	0.6
   C	3	21	0.3
   D	5	7	0.8

2. Long-touch a corner cell of the range (e.g. '1') and choose 'Specify Range' (or set it as the current cell and drag).
3. Long-touch another corner cell of the range (e.g. '0.8') and choose 'Draw Graph'.
4. Touch the icon in the action bar and choose a graph type.

It is arbitrary whether the column labels(X,Y,Z) and row labels(A,B,C,D) are included in the range. For example, you can specify the range without labels('1'-'0.8'), with both labels('Test'-'0.8'), with column labels('X'-'0.8'), or with row labels('A'-'0.8').

Please try drawing by using the above example (You can copy above table data and paste it into the QESS sheet).

Only numerical values can be used for drawing. If the cell value cannot be converted to numeric one, it is assumed as zero. But when the top row or left-end column has a String type cell, the row/column is assumed as labels (blank cell is String type).

The data sets numbered 'first', 'second', and 'third' from the leftside are interpreted as follows.

Line chart

When the label column is included or the count of the data set is 1: All data sets include values of the y-axis. The x-axis shows label values or serial numbers (0,1,2,..).
Otherwise: The first data set includes values of the x-axis. Following data sets include the values of the y-axis.

Stacked bar chart

When the label column is included or the count of the data set is 1: All data sets include values of the y-axis. The x-axis shows label values or serial numbers (0,1,2,..).
Otherwise: The first data set includes values of the x-axis. Following data sets include the values of the y-axis.

Grouped bar chart

Two or more data sets are needed. All data set include values of the y-axis. The x-axis shows label values or serial numbers (0,1,2,..).

Pie chart

Only the first data set is used.

Scatter chart

When the label column is included or the count of the data set is 1: All data set includes values of the y-axis. The x-axis shows label values or serial numbers (0,1,2,..).
Otherwise: The first data set includes values of the x-axis. Following data sets include the values of the y-axis.

Radar chart

All data set are used.

Bubble chart

Two or more data sets are needed.
When the label column is included or the count of the data set is 2: The first data set includes the value of the y-axis, the second data set includes the bubble sizes. The x-axis shows label values or serial numbers (0,1,2,..).
Otherwise: The first data set includes the value of the x-axis. Following data sets include the values of the y-axis and bubble sizes in turn (I.e., the data sets are [x, y, size, y, size, y, size, ...].

Candlestick chart

Four or more data sets are needed.
When the label column is included or the count of the data set is 4: The data sets from 1 to 4 describe [Open value, High value, Low value, Close value]. The x-axis shows label values or serial numbers (0,1,2,..).
Otherwise: The first data set includes the value of the x-axis. Following data sets describe [Open value, High value, Low value, Close value]. Other data sets are neglected.

The selected graph type is also used in the next drawing. The drawing might be failed caused by the values and the range. If the drawing is failed, retry after modifying the values or the range.