Data Visualization

Turn your sheet data into charts. Select a data range and create line, bar, pie, or area charts to visualize trends and comparisons.

Creating a chart

1. Select the data range you want to chart (include column headers)
2. Click the Chart button in the toolbar
3. Choose a chart type
4. Configure the chart options
5. The chart is embedded in your sheet

Chart types

Bar chart

Best for comparing values across categories.

Example: Monthly revenue by product line — each bar represents a product, grouped by month.

Line chart

Best for showing trends over time.

Example: Weekly active users over the past quarter — the line shows whether usage is growing or declining.

Pie chart

Best for showing proportions of a whole.

Example: Revenue breakdown by region — each slice shows what percentage each region contributes.

Area chart

Like a line chart but with the area under the line filled in. Good for showing volume over time.

Example: Cumulative sales throughout the year — the filled area emphasizes total volume.

Configuring charts

After creating a chart, click it to open the configuration panel:

• Title — add a chart title
• X-axis — select the column for the horizontal axis
• Y-axis — select one or more columns for the vertical axis
• Legend — show or hide the legend, set position
• Colours — customize series colours
• Labels — show or hide data labels on bars/points

Updating charts

Charts automatically update when the underlying data changes. Edit a cell and the chart reflects the new value immediately.

To change the data range, click the chart and update the range in the configuration panel.

Next steps

• Formulas & Functions — calculate data for your charts
• Sharing & Permissions — share sheets and charts with your team
• Introduction to Sheets — overview of all features