Changing chart data
Quattro Pro lets you change chart data by adding or removing a series and by changing the data range of a series. For most chart types, you can change only the Y range, however for XY, XYX, bubble, and high/low charts you can change other ranges. For example, in a bubble chart you can change the Y range, the X range, and the size range.
To add a series |  |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
 Source data. |
|
3.
|
|
Click Add.
|
|
4.
|
|
Click the Range picker
 in the Y-range box, and select a data range. |
|
•
|
|
When you add a series to a chart, it is placed as the last series.
|
|
•
|
|
You can also add a series by selecting the data and dragging it onto the chart.
|
To remove a series | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Source data. |
|
3.
|
|
From the list, choose the series you want to remove.
|
|
4.
|
|
Click Remove.
|
|
•
|
|
When you remove a series, all the series following it are renumbered accordingly.
|
|
•
|
|
You can also remove a series by selecting it and clicking Delete.
|
To change the data range of a series | |
|
1.
|
|
Type a new data range on a spreadsheet.
|
|
2.
|
|
Click a chart.
|
|
3.
|
|
Click Chart
Source data. |
|
4.
|
|
Choose a series from the list.
|
|
5.
|
|
Click the Range picker
in the Y-range box, and select the new data range. |
To change the data range of a series in an XY or XYX chart | |
|
1.
|
|
Type a new data range on a spreadsheet.
|
|
2.
|
|
Click an XY or XYX chart.
|
|
3.
|
|
Click Chart
Source data. |
|
4.
|
|
Choose a series from the list.
|
|
5.
|
|
Click the Range picker
in any of the following boxes, and select the new data range: |
|
•
|
Y-range
|
|
•
|
X-range
|
To change the data range of a series in a bubble chart | |
|
1.
|
|
Type a new data range on a spreadsheet.
|
|
2.
|
|
Click a bubble chart.
|
|
3.
|
|
Click Chart
Source data. |
|
4.
|
|
Choose a series from the list.
|
|
5.
|
|
Click the Range picker
in any of the following boxes, and select the new data range: |
|
•
|
Y-range
|
|
•
|
X-range
|
|
•
|
Size
|
To change the data range of a series in a high\low chart | |
|
1.
|
|
Type a new data range on a spreadsheet.
|
|
2.
|
|
Click a High\Low chart.
|
|
3.
|
|
Click Chart
Source data. |
|
4.
|
|
Choose a series from the list.
|
|
5.
|
|
Click the Range picker
in any of the following boxes, and select the new data range: |
|
•
|
High — lets you select the data range for the high values
|
|
•
|
Low — lets you select the data range for the low values
|
|
•
| Open — lets you select the data range for the open values
|
|
•
|
Close — lets you select the data range for the close values
|
|
•
|
Volume 1 — lets you select the data range for the volume values
|