Article Image

How to make a graph or chart in Google Sheets

Wondering how to make a graph in Google Sheets? Open your spreadsheet and get your data ready. It’s time for a crash course on chart creation in Google Sheets.

Graphs and charts are fantastic tools for displaying data in an attractive visual format. This can make seeing data at a glance easy, which allows you to spot patterns or anomalies quickly.

With the graph options available in Google Sheets, you can make a line, bar, column, pie, or other type of chart in just minutes. Then, tailor the graph to your liking with colors, a legend, gridlines, and more.

Here’s how to make a graph in Google Sheets and customize it.

PC, laptop, tablet, or smartphone with Google Sheets access.

Creating a chart in Google Sheets starts with the data. While you can add data to a graph after you create one, it’s best to start with at least one data set.

Depending on the data you select for your chart, Sheets will recommend the chart it thinks fits your data best. But you’re free to pick whichever type of graph you like. However, it is a good idea to sort your spreadsheet data first, to ensure the graph displays everything in the right way.

Step 1: Select your data by dragging your cursor through a range of cells or clicking column and row headers.

Step 2: Open the Insert menu and choose Chart.

Step 3: You’ll immediately see a default graph appear on your sheet. This is the one that Sheets suggests for you. You can keep the chart or choose a different one in the Chart Editor sidebar that appears with the chart.

Step 4: To pick a different graph, select the Setup tab in the sidebar. At the top, click the Chart Type drop-down box.

You’ll see more suggested charts at the top with all remaining types below. Pick a graph you’d like to use, and the default graph on the sheet will update to the new type.

Step 5: Once you choose the type of chart you want, you can adjust the additional options on the Setup tab for the data you want to display.

After you insert your chart and select the Setup options, you can customize various elements of it in the Chart Editor sidebar.

If you closed the sidebar, reopen it by clicking the three dots on the top right of the chart and choosing Edit Chart.

Step 1: Select the Customize tab at the top of the sidebar. You’ll see several elements in expandable sections. Simply expand a section to work with that part of the chart.

Step 2: Each section you see depends on the chart type you’re using. For instance, if you have a bar chart, you’ll see options too for the horizontal and vertical axes, and if you use a pie chart, you can adjust the pie slice.

Step 3: Although each type of graph in Google Sheets comes with its own elements, here are a few that are available on various chart types that may interest you.

Step 4: When you finish customizing the chart, click the X on the top right to close the Chart Editor sidebar.

You can move your chart to any spot on your sheet. Simply select it and drag it to its new position.

To resize your graph, drag from a corner or edge, inward or outward.

For additional actions, click the three dots on the top right of the chart. You can reopen the sidebar with Edit Chart or remove it with Delete Chart. You’ll also see options to download, publish, copy, or move the chart to a new sheet.

Creating a graph in Google Sheets is as easy as making a graph in Microsoft Excel, and with the customization options available, you can give it the exact appearance you want.

Not sure which spreadsheet application is best for you? Check our comparison of Google Sheets vs. Microsoft Excel.

The absolutely absurd idea of putting a touchscreen display on a mouse isn't exactly new. Turtle Beach already did it with its Command Series MC7, which features a 2.25-inch control screen. But apparently, even that wasn't ridiculous enough for Arctic Fox Technologies. Its new Super Mouse looks like someone took the chunky old Atari ST mouse, slapped a touchscreen and scroll wheel on it, and called it an upgrade.

The result is a rather unusual-looking mouse that is now on Kickstarter, starting at $199. And as ridiculous as it looks, some of its features are genuinely intriguing.

Apple is less than a day away from launching its highly anticipated OLED MacBook Pro with a touch-sensitive screen. But it appears that the upgrade is going to cost a pretty penny. According to a report by Bloomberg, Apple is reportedly eyeing a starting price of $2,899 for the 14-inch MacBook Pro, while the 16-inch version could start at $3,399 in the US.

"At $2,899, the 14-inch model would mark the highest starting price for a new MacBook Pro model, surpassing the $2,799 Apple charged for a 17-inch version introduced in 2006," says the report. The report claims that Apple is targeting a minimum price hike of $400 for its upcoming redesigned 14-inch and 16-inch MacBook Pro models.

I've spent a good amount of time digging into the spec sheet of the new M6 MacBook Pro (14-inch), and for all intents and purposes, this is a classic Apple "chip and connectivity" refresh. It's not a full redesign. The chassis, Liquid Retina XDR panel, speakers, ports, and battery, all of them carry over unchanged.

However, the M6 brings more cores, stronger on-device AI, higher memory bandwidth on the larger configs, and modern wireless. Here’s the practical rundown of what actually improved, and whether those gains are worth your money.