Entering/editing the data of a chart |
  
|
Entering/editing the data of a chart |
|
When you create a new chart, the values 1, 2, 3, and 4 are entered in it by default. These values are just sample values to ensure that the chart is not completely empty when displayed.
You can use the ribbon command Chart | Edit data to edit these values at any time and enter your own values.
Proceed as follows:
| 1. | Click to select the relevant chart and the contextual ribbon tab Chart will appear. |
| 2. | Choose the command Chart | Edit data  here. |
| 3. | The dialog box "Data source" opens. In the Y values column, enter the values to be displayed in the chart. |
| Don't worry about the other columns and options; they are irrelevant for most chart types. |
| (For more information on all options in this dialog box, see below.) |
| 4. | Confirm with OK. |
The chart now updates and displays the values that you have entered.
Alternatively, you can open this dialog box by right-clicking on the chart and selecting Chart: Properties from the context menu.
In the following dialog box "Object properties", switch to the Series tab, and click on the Edit button there to open the dialog box "Data source".
Options of the dialog box
The aforementioned dialog box "Data source" has the following options:
▪Series
| Here, you can select which series to display in the dialog box in the case of charts with multiple data series. |
| Tip: To manage the data series of a chart, right-click on the chart and choose the command Chart: Properties in the context menu. Switch to the Series tab. On this tab, you can add, delete and edit data series. |
▪Rename button
| This button allows you to rename the data series that is currently selected in the Series list. Tip: This name is also displayed in the legend of a chart. |
The largest part of the dialog box is occupied by a table where you can enter the values:
▪X values
| The left column represents the X values. These values are required only by a few special chart types (for example, XY scatter charts). For all other chart types, this column is set to Automatic by default (via the appropriate checkbox above this column). |
▪Y values
| The middle column represents the Y values. Here, you usually enter the values to be displayed in the chart. |
▪Bubble sizes
| The right column is only to be filled for bubble charts and determines the size of the bubbles. |
▪Insert row button: This option inserts an additional row above the current row.
▪Append row button: This option appends an additional row below the last row.
▪Delete row button: This option deletes the current row.
▪Paste button: This option overwrites the values in the current data series with the values that are currently on the clipboard.
| Copy the desired Y values to the clipboard beforehand. Use a new line for each value. |
| See also the following notes. |
Some notes on the "Paste" button:
▪The Paste button can fill only one data series with data at a time. This means that you cannot copy, for example, a whole table to the clipboard and then paste it as multiple data series.
| Tip: However, you can achieve this at any time via a small "detour": Paste the contents of the table into the PlanMaker spreadsheet application (as table cells), create the chart from it, copy it to the clipboard, and then paste it into Write. For more information, see also Inserting charts via PlanMaker. |
▪If you want to insert X and Y values using the Paste button, first disable the Automatic checkbox above the X values column. The clipboard must, of course, contain two values in each row (X and Y). Separate them with a tab, a semicolon or the list separator set in your system.
▪The same applies to bubble charts. Here, the clipboard can contain up to three values per row: X, Y and the bubble size.
▪Text strings on the clipboard normally return the value 0 (zero). If a text string also contains numbers, however, the first number is extracted from it.
| Some examples: |
| "Euro" returns the value 0. |
| "50 Euro" returns the value 50. |
| "Euro 50" returns the value 50. |
| "50 Euro, 20 Cent" also returns the value 50. (Only the first number is always taken into account.) |
Adding/deleting data series
If you want to add a new data series to the chart or remove an existing data series, right-click on the chart and choose the command Chart: Properties in the context menu. In the following dialog box "Object properties", switch to the Series tab.
Click on the Add button here to add a data series. The new data series then appears in the list on the upper left of this dialog box. Then press the Edit button, and enter the values to be displayed in the following dialog box "Data source", as described above.
To remove a data series, select it in the list on the upper left of the dialog box "Object Properties", and click on the Delete button.