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 HCL Connections Docs. Likewise, when you create charts in HCL 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.