IBM Lotus Symphony


Inserting Charts

You can insert charts in a spreadsheet, presentation, and document.

  1. Open a spreadsheet and enter some data with row and column headings.
  2. Select the data together with the headings.
  3. Click Create > Chart. A chart is inserted and the Chart Wizard window is displayed.
  4. Define the chart type, data range, data series, and chart elements.
  5. 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 Layout > Arrange. The corresponding cell ranges in the spreadsheet will not be rearranged.

Tip:
  • When you insert a chart in a presentation with Create > Chart, 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 Create > Chart to insert a chart containing sample data.
  • You can change the sample data values by double-clicking the chart and then click Edit > Chart Data. 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 Layout > Chart Type, 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.


Product Feedback | Additional Documentation | Trademarks