Plotting chart data
How Quattro Pro plots data depends on the range and values of the cells you select before you create the chart.
When a selection contains more rows than columns or an equal number of rows and columns:
|
•
|
|
Quattro Pro plots each column as a single series.
|
|
•
|
|
If the first column contains labels, the labels are placed along the x-axis.
|
|
•
|
|
If the first row contains labels, the labels are used as the chart legend.
|
When a selection contains more columns than rows:
|
•
|
|
Quattro Pro plots each row as a single series.
|
|
•
|
|
If the first row contains labels, the labels are placed along the x-axis.
|
|
•
|
|
If the first column contains labels, the labels are used as the chart legend.
|
Setting up chart axes
All charts except pie and doughnut charts have two references for plotting data: the x-axis and the y-axis. The x-axis is a horizontal line at the bottom of the chart pane with fixed reference points; the column labels in your data series are used for x-axis labels to explain what each data series represents. Y-axis labels show the values being represented. Depending on the data series, Quattro Pro determines the range and increment amounts of the y-axis.
There are a few exceptions to this format:
|
•
|
|
Horizontal charts have a vertical x-axis and a horizontal y-axis. Quattro Pro reverses the axes of horizontal charts automatically.
|
|
•
|
|
In XY charts (scatter diagrams), the x-axis series is data, not labels. Quattro Pro scales the x-axis to match the data.
|
|
•
|
|
If the chart is a 2D bar, line, or area chart, you can assign any series to a secondary y-axis, which appears on the right side of the chart.
|