What does aggregate mean in Google Sheets chart

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to the chart type you need. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Steps

  1. 1

    Arrange categories and numbers in adjacent columns.

  2. 2

    Select the range including headers.

  3. 3

    Choose Insert → Chart.

  4. 4

    Set Chart type to the chart type you need and adjust Customize options.

Better Sheets on YouTube

Watch matching videos from youtube.com/bettersheets.

Search channel

Terms and formulas behind this

Want the full definition or how a formula works? Start here.

Related questions

How to add labels to chart in Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to the chart type you need. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Get the answer →

How to create a column chart in Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to the chart type you need. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Get the answer →

How to make column chart in Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to the chart type you need. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Get the answer →

How to make a column chart in Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to the chart type you need. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Get the answer →

How to add labels to pie chart in Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to Pie chart. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Get the answer →

Need more than a quick answer?

636+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.

Need one fix

Watch a free tutorial for the step-by-step version of any answer.

Learning Sheets for real

Unlock the full library, generators, and templates with membership.