How to Make a Graph or Chart in Google Sheets

  • MORE

After you've entered data into Google Sheets, you may want to create a visualization of that information to make it easier to convey. Luckily, Google Sheets makes it easy for you to convert data into a graph or chart.chartcover

Google Sheets gives you a variety of options for your graph, so if you want to show parts that make up a whole you can go for a pie chart, and if you want to compare statistics, a bar graph will likely make more sense. Here are our step-by-step instructions for making a graph in Google Sheets.

MORE: Best Chromebooks Available Now

1. Select cells. If you're going to make a bar graph like we are here, include a column of names and values and a title to the values. 

chart01

2. Click Insert.chart02

3. Select Chart.

chart03

4. Select a kind of chart. Pie charts are best for when all of the data adds up to 100 percent, and histograms work best for data compared over time.

charta

 

5. Click Chart Types for options including switching what appears in the rows and columns or other kinds of graphs.

chartb

6. Click Customization for additional formatting options.chartc

7. Click Insert.chart7

You've inserted a graph into your spreadsheet.chartend

Author Bio
Henry T. Casey
Henry T. Casey,
After graduating from Bard College a B.A. in Literature, Henry T. Casey worked in publishing and product development at Rizzoli and The Metropolitan Museum of Art, respectively. Henry joined Tom's Guide and LAPTOP having written for The Content Strategist, Tech Radar and Patek Philippe International Magazine. He divides his free time between going to live concerts, listening to too many podcasts, and mastering his cold brew coffee process. Content rules everything around him.
Henry T. Casey, on
Add a comment