How to make a log graph 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.

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.

Related tutorials

These videos might help you go deeper on this topic.

Browse more tutorials
Build Your Own AI Writer in Google Sheets

Build Your Own AI Writer in Google Sheets

Create your own AI writer with these google sheets tips and tricks and c...
Learn to Code in Google Sheets, For Programmers

Learn to Code in Google Sheets, For Programmers

Google Sheets uses a scripting language called Google Apps Script, which...
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hou...

Related blog posts

Written guides that go deeper on this question.

Browse the blog

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 make graph 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 pie graph 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 →

How to make a bar graph 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 Bar 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 →

How to make a circle graph 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 do you make a line graph on 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 Line 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?

637+ 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.