Inserting charts in spreadsheets

You can insert a chart into a spreadsheet.


  1. Select the range for which you want to insert a chart.
  2. Click Insert > Chart or click the Insert Chart icon the icon to insert a chart on the toolbar.
    Tip: You can also right-click the data range and select Insert Chart.
  3. Select a chart type and then click OK. You can also double-click the chart type that you select.
  4. Optional: To preview how the chart looks with the data series in rows or in columns, click Data and then click the option you want.
    a preview of the selected chart type
  5. If you want to save the chart, you can right-click the chart and select Download as Image to save it in .png format.


  • When files in other formats (.xls, .xlsx, and .ods) contain charts, the charts are retained in their supported types when you edit the file in IBM® Connections Docs. Likewise, when you create charts in Connections Docs and download the file to those formats, the charts are intact.
  • You cannot group charts that you insert into a spreadsheet. When you import spreadsheets that already contain grouped charts, you must act on each object separately.