Chart types in spreadsheets

When you want to show comparisons and trends in a series of data, you can create charts in spreadsheets.

Charts are a great way to communicate numeric data graphically. A chart makes it easy to see trends and to make comparisons. To show data in a clear way, you can insert charts in spreadsheets. IBM® Connections Docs spreadsheets support many types of charts, including column charts, bar charts, pie charts, area charts, line charts and scatter charts.


You can create a line chart to show the trends in data at specific intervals. You can also create a column chart to show seasonal sales volume in different regions.

When to use each type

See the following topics for tips on which type of chart can best serve your purpose.