|
|
Changing the Data Range of a Chart
From NeoWiki
(Difference between revisions)
| Revision as of 20:44, 19 November 2007 (edit) Jgd (Talk | contribs) m (fixme) ← Previous diff |
Revision as of 01:27, 20 November 2007 (edit) (undo) Lorinda (Talk | contribs) m (→Modifying Data in the Original Range - correct typo) Next diff → |
||
| Line 3: | Line 3: | ||
| ==Modifying Data in the Original Range== | ==Modifying Data in the Original Range== | ||
| - | Select the cells you want to modify, | + | Select the cells you want to modify, and edit the data they contain. The chart is automatically updated. |
| ==Modifying the Original Range== | ==Modifying the Original Range== | ||
Revision as of 01:27, 20 November 2007
This article is not up to date, or it needs structural or stylistic changes to conform with the rest of this wiki.
When you have created a chart in a spreadsheet, using data from a range of cells, you can modify this range by editing, removing or adding data.
Modifying Data in the Original Range
Select the cells you want to modify, and edit the data they contain. The chart is automatically updated.
Modifying the Original Range
- To delete data from the original range :
- Select the cells you want to remove, then press the Delete key. The chart is automatically updated.
- To add data to the source range, apply the following method:
- Right-click or Control-Click on the chart.
- In the contextual menu that appears, select Modify Data Range….
- In the Modify chart data range window that appears, in the Range field, you can modify the data range in two ways:
- by clicking on the Shrink button with a green arrow at the right hand of that field, then by selecting the new range and clickng on the Maximize button with the green arrow
- by entering by hand the definition of the new range.
- Click on the Create button to perform the modifications.
This article in other languages: Français
