Create a chart
1. Create a chart
Creating a chart in Sheets is easy. Here we can see sales for two stores in Spain. There are a lot of numbers here, so let's create a chart so we can better visualize the data. Select cells A1 through M3, then choose the insert chart icon on the toolbar, or choose Chart from the insert menu. Expand the chart on the sheet. The chart's editor pane opens on the right, and Sheets automatically chooses the most appropriate chart type for your data. We can change the type in the chart editor. Set the chart to be smooth line type. Now let's explore some of the customization options. Click Customize in the chart editor pane. Expand the chart and axis title section, and change the chart title to Spanish units sold. Change the title font size and color. Suppose we want to see the sales trend for each store. Expand series, and check trend line. Here we can see that there's a slight upward trend in sales for both stores. Let's imagine that all the Spanish stores commit to selling at least 6,000 units per month. In that case, let's reset Start the Baseline, expand vertical axis, and set the minimum value to 6,000. See how the chart now starts at 6,000 units? Finally, let's add the data values to the chart. Expand series, and check the data labels box. You'll have time to explore the chart's editor later. One of the strengths of Google Workspace is that apps like Sheets can connect to other Google services like Google Maps. Let's explore creating geo or map based charts. Select cells A1 through B11. Then choose the insert chart icon on the toolbar, or choose chart from the insert menu. Expand the chart on the sheet. Let's see what this data looks like on a map. Change the chart type to geo chart. Now we can see colors representing the sales in each country. Let's make some changes. Click Customize in the chart editor pane. First, we are only interested in Europe, so let's change the map to display Europe only. Let's change the colors also. Change the min, mid, and max values to light blue three, light blue one, and dark blue one respectively. If we hover over each country, we can see the number of units sold. Let's imagine we've opened a store in Dublin. In row 12, enter Ireland and 350,000. Notice how Sheets automatically adds the new store to the chart. We didn't even have to adjust the chart's range. Sheets also allows you to show a simple chart in a cell. Let's see that now. Enter the following formula into cell N2: Equal sign sparkline (B2:M2) Sparkline allows you to visualize a range of cell data in a single cell. Like any formula, we can push that down to other rows in the sheet. Double click on the bottom right corner of cell N2 to reveal the sparkline for Barcelona in row three.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.