You can insert charts in a spreadsheet, presentation, and
document.
- Open a spreadsheet and enter some data with row and column headings.
- Select the data together with the headings.
- Click . A chart is inserted and the Chart Wizard window
is displayed.
- Define the chart type, data range, data series, and chart elements.
- You can create a chart with the default settings. Click Finish.
You are free to make any changes to
all objects of your own charts. You can either double-click on the
objects or, with the chart selected, choose the commands from the Layout
menu. For example, if you double-click any area in the legend, you
can change the format of the legend including the background, borders
and so on.
If you created the chart
from the data of a spreadsheet, the data series that you click on
in the chart are highlighted in the table.
In
a chart, you can move a data series forward or backward. To change
the arrangement in the chart, use a command in the context menu of
a data series or choose . The corresponding cell
ranges in the spreadsheet will not be rearranged.
Tip:
|
- When you insert a chart in a presentation with ,
it is displayed with a set of sample data. When you insert a chart
in a spreadsheet, you first select the cells in the spreadsheet whose
values should be displayed in the chart.
- In documents, you can insert a chart obtained from the data of
a table. If you do not select any data in a table, click to
insert a chart containing sample data.
- You can change the sample data values by double-clicking the chart
and then click . If you want to change the values of
a chart obtained from selected cells, you have to change the values
in the table cells. If the chart is in a document, press F9 (Mac special use)
to update the chart.
- An easy method to change the numbers in a chart is drag-and-drop:
select any table cell range, then drag and drop them at the chart.
The chart updates with the new values.
- Modification of chart data is also possible if you, for example,
have copied a chart from a spreadsheet into a document and now double-click
the chart in the document. Remember, however, you are only editing
the copy and not the original document.
|
You can change the type of chart
any time. When you double-click the chart and choose , a window opens, presenting you with various types
to choose from.
Try out the different
options in the Chart Type window. You can also
switch between 2D and 3D representation.
- The three-dimensional charts offer some special effects. For example,
you can adjust the illumination settings, such as light source, ambient
light and color filters.
- 3D charts can be rotated and tilted with the mouse for an optimal
point of view.
- In Line charts you can use the data series symbols that are applied
automatically by chart. You can also select symbols yourself from
graphic files or from the Clip Art.