How to make a chart in Google Sheets

Google Sheets allows you to add different types of charts and graphs to your spreadsheet, so you can turn your boring data into attractive and easy-to-read visualizations. Dozens of options are available, including commonly used options such as bar and pie charts, as well as lesser-known images such as scatter plots and tree maps.

In the following steps, we’ll show you how to create a chart or chart in Google Sheets cross-platform, using bar charts as an example.

We assume you know that the chart itself is derived from the data you entered into the table (even if you inserted that data from other sources).

Create a histogram

As mentioned above, there are different types of charts that can show your data in a more attractive way. Follow these instructions to create a bar chart, which can be changed to a different type later in the tutorial if desired.

Desktop/Laptop (most web browsers; Google Chrome preferred)

  1. Open an existing spreadsheet or create a new spreadsheet from scratch.

  2. Optionally, enter any data you want to use in the histogram. This data should usually be in the form of a table, as shown in the attached screenshot.

  3. Select all cells that contain the data you want to include in the bar chart, including headers if necessary. You can skip this step and define the data range after the chart has already been created, although it is usually much easier to do this way.

  4. Choose an option Insert in the Google Sheets menu at the top of the screen. When the drop-down list appears, click Diagram

  5. Your chart will now appear, overlapping some cells in your spreadsheet. Click and drag it to the desired location. You can also adjust the size at this point by clicking and dragging the blue corner or side indicators, respectively.

  6. Couple Chart editor should also be visible on the right side of your browser window. Click on title DATA if not already selected. Then select the drop-down menu under Chart type

  7. A thumbnail image should now be displayed representing every available chart and chart type, categorized. Scroll down to the section labeled Bar and select the first option, bar chart

  8. If you skipped step 1 and still need to define the source for your histogram, click the button in the section Data range and enter one or more cell groups that contain the data you want to use. portrayed.

  9. At this point, the base of your histogram should be in place. As you can see, in the interface diagram editor There are many other customizable options that you can play around with until the layout and content of your chart are to your liking.

Android/IOS

  1. Launch the Google Sheets app.

  2. Open an existing spreadsheet or create a new spreadsheet from scratch.

  3. Optionally, enter any data you want to use in the histogram. This data should usually be in the form of a table, as shown in the attached screenshot.

  4. Select all cells that contain the data you want to include in the bar chart, including headers if necessary.

  5. Press the button Insert indicated by a plus sign (+) at the top of the screen.

  6. When the menu appears Insert select Diagram

  7. A preview of what your chart will look like is now displayed with some customizable options. Click on the icon with the text Type

  8. A set of more than a dozen charts and graphs should be visible, divided into categories. Scroll down to the section labeled BAR and select the first option. Please note that some types of charts and graphs are only available in the desktop version of Google Sheets and are not available for Android or iOS devices.

  9. Click the check mark in the top left corner of the screen.

  10. Your bar chart should now be in place, over the existing cells in your spreadsheet. Drag it to the desired location, preferably below or next to the data table.

To edit the chart later, double click it to enter the interface diagram editor (browser version), or tap it and select Edit chart † button (app for Android/iOS).

Other chart types

In the example above, we showed you how to create a bar chart, just one of many charts available in Google Sheets. By following the same steps and choosing a different type when prompted, you can add one or more of the following to your spreadsheet. As you will see, some options are only available in the browser version of Google Sheets.

Line charts

  • default-

  • Soft; soft

  • combination

Territorial Charts

  • default-

  • Folded area

  • 100% folded area (browser only)

  • step zone

  • Stacked stepped area (browser only)

  • 100% stacked stepped area (browser only)

Bar charts

  • default-

  • stacked

  • 100% stacked

Histograms

  • default-

  • stacked

  • 100% stacked (browser only)

Pie points

  • default-

  • donut

  • 3D

Accurate Charts

  • default-

  • bubble

map of cards

  • Geo (browser only)

  • Geo with markers (browser only)

Various charts

  • Waterfall (browser only)

  • Sparkline (browser only)

  • Histogram (browser only)

  • Radar (browser only)

  • Sensor (browser only)

  • candle holder

  • Organizational (browser only)

  • Tree map (browser only)

  • Timeline (browser only)

  • Table (browser only)

Leave a Reply

Your email address will not be published.