|
|
Changing the Data Range of a Chart
From NeoWiki
(Difference between revisions)
| Revision as of 20:35, 19 November 2007 (edit) Jgd (Talk | contribs) (translation of the French page Fr:Modifier la Plage de Données d'un Diagramme) ← Previous diff |
Current revision (08:01, 20 November 2007) (edit) (undo) Valterb (Talk | contribs) (botlangbar -> IT and remove category NeoWikiFR) |
||
| (3 intermediate revisions not shown.) | |||
| Line 2: | Line 2: | ||
| ==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== | ||
| Line 16: | Line 16: | ||
| - | {{botlangbarEN|[[Fr:Modifier la Plage de Données d'un Diagramme|Français]]}} | + | {{botlangbarEN|[[Fr:Modifier la Plage de Données d'un Diagramme|Français]] [[It:Cambiare_l%27Intervallo_di_Dati_di_un_Diagramma|Italiano]]}} |
| - | [[Category:Tips and Hints]][[Category:NeoOffice | + | [[Category:Tips and Hints]][[Category:NeoOffice]] |
Current revision
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.
