Home » Google Sheets Charts: An Easy Guide to Making Beautiful Charts Show
Google Sheets Charts: An Easy Guide to Making Beautiful ChartsA visually appealing and well-laid-out chart is at the heart of every project when it comes to visualization. Luckily making charts in Google Sheets is easy, and you will create beautiful charts that visually display the data already stored in your Google Sheets file. Google Sheets Charts include numerous chart types, from simple bar and pie charts to more complex radar, treemap, and geo (using Google Maps) charts. This Google Sheets Charts tutorial will provide you with the knowledge to create even the most complex charts on Google Sheets. Table of Contents
Creating a ChartCreating a chart is super simple and can be done in two ways. The first step in both methods is to select the data you would like to visualize (do this by clicking and dragging over the data range). For step two, you can either go to the menu bar and select Insert, then select chart in the dropdown menu. The second option for step two is to select the Chartbutton in the toolbar. Google Sheets will then select the chart it feels your data fits. This is an automated process and can be incorrect at times. However, often this prediction may be correct. It will create a chart and use the data to fill in the title, legend, and axes. You will also notice that the Chart editorsidebar loads at this time. Please note that if you close the Chart editor and then want to reopen it later, you can do so by double-clicking anywhere on the chart. Google Sheet Chart TypesNow that you have created a Google Sheets chart, lets look at the various charts available in Google Sheets. We will begin with the most commonly used chart and work on the more complex types of charts. Pie ChartsPie Charts are perhaps the most commonly used charts. Most people would be very familiar with a pie chart, and they do a great job of visualizing simple data. They are used commonly with budgeting as it depicts a single item (i.e., spending). Pie charts use a circle, disk, or donut divided into sections based on the data. Line and Area ChartsLine charts and Area charts are very similar. Both use an x-axis to show a period (i.e., month), and the y-axis shows the metric visualized. The only difference between them is a bit more color. A line chart is a rectangular chart that has dots going across it and lines connecting the dots. Whereas, for an Area chat, the space below the line is shaded in. This could perhaps make the visual much quicker to identify. Both charts can be used to visualize the changes of numerous metrics over time. Column and Bar ChartsThese charts resemble Line and Area charts in the overall layout, but you will have columns or bars instead of dots connected by lines. They will not be connected, thus allowing you to compare multiple metrics side by side for each period (i.e., week). Learn more: How to Make a Bar Graph in Google Sheets Stacked Column, Bar, and Area ChartsStacked charts are similar to their standard versions. However, the metrics are stacked in different colors to show the changes in the composition of various items over time. Scatter ChartsScatter charts have a diagonal line (x-y plane) going from bottom left to top right moving up the metrics results. Then the data is visualized as dots around that line. These dots create a scatter plot that highlights the target areas. Often this is used to get a simple overview of property cost and square footage. It can be used effectively to show connections between two metrics. Learn more: How to Make a Scatter Plot in Google Sheets Geo ChartsThese charts use a map, and they show concentration by area. They are great for visualizing sales data when attempting to understand the target market areas of a companys customer base. Google Maps offers a map for this chart that is built into Google Sheets Charts. The Chart EditorThe chart editor is, as it sounds, the place where you can edit your chart. This editor will allow you to change the data range, chart type, visual effect, and more. It consists of 2 sides: the Setup Editor and the Customize Editor. Setup EditorData Range
X-axis
Aggregate Check Box
Series
Checkboxes
Customize EditorChart style
Chart & axis titles
Series
Legend
Vertical Axis
Gridlines and ticks
Downloading Your ChartAfter creating a chart, you may need to download it to distribute it to your team via email. Luckily Google Sheets has this built-in and allows you to download your file to a PNG, PDF, or SVG. To do this, you will need to hover your cursor over the chart. When you do this, three dots should appear in the top right corner of the chart. Click the three dots, and you will see a dropdown. Go to Download and select the file type you would like to download. Advanced TipsGoogle Sheets Charts have some more advanced options that we will not cover in full here, but this will provide you with other options for your chart.
ConclusionGoogle Sheets Charts are a top-shelf data visualization tool that will create visuals to present your data. These visualizations are the key to making informed decisions and delivering effective points. Hopefully, this tutorial will allow you to use this incredible tool effectively, and you will become more effective at making charts in Google Sheets. Read more Google Sheets chart tutorials here:
Related posts:How to Print on One Page in Google Sheets (Fit to Page) How to Insert Multiple Columns in Google Sheets (Easy Methods) How to Make a Gantt Chart in Google Sheets How to Find Absolute Value in Google Sheets [3 Ways] Jon FlattJon has worked in administrator positions for the last decade and has a specific knack for using Google Sheets to help small businesses. Jon consistently applies his skill set to allow small businesses and new Google Sheet users to advance and grow. Best Online Google Sheets CoursesBecome a Google Sheets expert today! View Course |