How to Make Professional Charts in Google Sheets

Read Time: viii mins Languages:

Chartsare visual summaries of our information. Information technology's much easier to detect meaning in a beautifully illustrated pie chart or bar graph than a list of information. A well-placed chartin your presentation tin help your audience accept an "aha!" moment to understand your information.

This simple pie chart, fabricated in Google Sheets, shows the breakdown of sales by 24-hour interval of week. You lot tin quickly run across that almost days are equal, with Friday being the business' best twenty-four hours.

When I accept a large list of information, I frequently volition throw it into a nautical chart chop-chop to analyze it. If I'm looking for trends, or the largest part of the whole, information technology will rapidly leap out in a chart. Charts are all about bringing meaning to your information.

One of my favorite tools to create charts isGoogle Sheets. It'southward complimentary and lives inside your browser, and so no need to purchase some other tool like Microsoft Excel. In this tutorial, I'll teach you how to use Google Sheets to easily create bonny charts.

How to Quickly Make Google Sheets Charts (Watch & Acquire)

If y'all want to become started with charts in Google Sheets, check out the screencast beneath. I'll walk you through creating your very first chart inside of Google Sheets.

The tutorial below has more than examples of how to use charts in Google Sheets. Read on to become a master of visual data.

How to Make Your First Google Sheets Chart

If you've not created your Google account, get-go off by jumping over to the Google Drive homepage. Y'all can login with your existing Google account, or create a free Google account to become started.

1. Create a Sheet

Later you've logged into your Google Drive account, create a new canvass by clicking onNewand choosingGoogle Sheets.This will create a new spreadsheet where yous can add your information, and so build charts utilizing that data.

Get toNew > Google Sheetsto create a new spreadsheet.

2. Add Your Data

Every chart begins with data inside of a Canvass. Each record should be on its own line in the spreadsheet.

Use one row of data for each category you want to summarize your data past.

If you want the chart to show a summary of your information, brand certain and grouping the data before creating a new nautical chart. For example: sum up your results past month instead of using each individual twenty-four hours will go on your nautical chart nice and clean.

3. Highlight the Information

After you've logged your information inside of a spreadsheet, highlight the columns that you wish to include inside of your chart. My favorite mode to do this is only to click on the column headers (the vertical lines with letters above them) and highlight them.

Highlight the columns that include your information to create your first chart.

It'due south best to highlight the entire cavalcade. This way, adding more rows to the data later on will automatically include them in the chart, and it volition update in existent fourth dimension.

You tin besides highlight only the columns that you want to include your information. Click on a column to include it in the chart, and and so agreeCtrlon Windows (Cmdon Mac) and click on another column header.

4. Choose Insert > Chart

Once y'all've selected your data, find theInsertbill of fare merely above the spreadsheet. ChooseNautical chartto insert your chart into your Google Sheets.

With your information selected, browse toInsert > Nautical chartto create your offset chart.

5. Cull a Google Sheets Chart Format

Now that you've launched the Google Sheets nautical chart creator, you lot tin choose between a variety of different chart formats  The type of chart that you choose should be based upon the format of the data you're working with, and the way you wish to present the data (more than on that in a infinitesimal.)

After y'all launch the chart editor, in that location are several tabs to create your first chart. One of my favorite features of Sheets is that information technology suggests nautical chart types. Information technology really looks at the data you selected, and suggests a chart that fits the information structure. TheRecommendations tab containsseveral ideas and variants to present your information.

Google Sheets Chart Editor recommendations.

If you don't like the recommendations, cull theNautical chart Typescarte to choose from all of the possible chart formats. You lot can select class a variety of chart types, and likewise slight variations on each chart type (like polish lines instead of jagged ones for line charts.)

Modified chart type in Google Sheets.

You can also chooseCustomizationto tweak the presentation of your nautical chart. I adopt to insert my chart showtime, and then tweak it every bit needed.

6. Customize Your Google Chart

After you lot've placed your chart into your Google Canvas, you tin can customize it to look exactly the manner you desire, including updating the championship of the nautical chart and changing its presentation style.

Modify your chart presentation way with Advanced Edit.

To access the editing options, correct click (command click on Mac) on your newly placed chart and chooseAdvanced Edit. This opens up the chart editing options to design the chart to your liking.

There are a litany of options for customizing your nautical chart, ranging from changing the chart title or the colors of your line. Beneath, you tin can see an example of a modified chart:

Modified Google Sheets nautical chart case.

Observe that you tin also switch back to theChart typestab on the carte if you lot want to change the entire nautical chart.

You lot've created your first Google Sheets chart. Now, it's fourth dimension to call up about how best to use them and how each type differs. Let'due south keep learning.

4 Mutual Types of Google Charts (And When to Use Them)

Google Sheets allows you to create a diversity of unlike charts. Hither are visual examples of each type of chart with guidance on when you might use each 1.

1. Line Charts

• When to Use Them - To show your audience how the data has changed over fourth dimension.
• Example - Prove the visitor'due south salary expense, month-past-calendar month.

A line chart is keen for time series data. For case, if you desire to see how your company is performing each month, you lot could plot the revenues over time to show the fluctuations in the visitor's results.

Line charts are perfect to show fluctuations over a period of time.

2. Area Charts

• When to Use Them - Visualizing 2 related parts that make upwardly a total.
• Instance - Show the full employee cost past stacking the salaries and benefits.

Area charts give you a sense of scale past coloring in the area beneath the lines. I similar to use these to "build up" a cost or corporeality by stacking the bars on top of each other.

Area charts focus on shading area below lines to create visual indicators.

Sheets features a multifariousness of ways to present area charts. In the instance higher up, I've got my employee costs illustrated in a nautical chart. The combination of salaries and benefits are the full employee cost.

3. Column Charts / Bar Charts

• When to Use Them - Showing the peak of each item, and comparing it to related items.
• Instance - Employ a stacked bar chart to correspond the values of your daily steps, easily comparing it other days.

Column and bar charts are similar, as they use vertical lines to prove values.Column chartsuse vertical lines, whilebar chartsare horizontal lines. In either case, they can aid you lot understand the magnitude of the items they represent.

Bar charts are visual indicators that bear witness you the magnitude of values using lines.

4. Pie Charts

• When to Utilize Them - Showing how the parts chronicle to the whole.
• Example - Showing the percentage of your time you lot spend on each project.

A pie nautical chart is a classic presentation tool, showing how the parts of data relate to the whole. You tin can use a pie nautical chart to depict attention to how much fourth dimension is being spent on certain types of work, for example.

A Google Sheets pie chart will automatically assistance yous calculate the percentages. Put your information in ii columns and create a pie chart to automatically divide upward your values into categories.

A pie chart divides items up into a "pie" which each slice of the pie representing its proportion; a larger piece indicates a larger share in the data.

Which Google Sheets Chart Type Should I Utilize?

Choosing any chart does come down to personal choice, as many of the styles have overlap in how they could be used with your information. It's easy to switch between chart styles or tweak the specifics in Sheets.

My height tip for using charts is to first by thinking nigh what yous're trying to tell the audience. Recall about what that data means, and choose Google nautical chart styles that convey that bulletin.

Recap and Continue Learning

Many people place themselves every bit visual learners. I think the best part about charts is that they acknowledge that we all learn and sympathise in different ways. Your audience is probable full of visual learners, and charts can aid bulldoze your message.

Envato Tuts+ has a wealth of resources about spreadsheets and presentations. Bank check out these tutorials to keep learning:

• The reward of Google Sheets is its ability to connect to other web services, similar Google Finance. Try out stock tracking with How to Track Stock Data in Google Sheets.
• Sheets also allows you to connect to other services using IFTTT like Twitter, Dropbox, and more.
• Melissa Tater has a not bad tutorial on how to Plough Your Google Docs Course Responses Into Beautiful Visualizations, which volition teach you surveyingandcharting in ane tutorial.

Do you lot have whatsoever questions nearly charts? The comments are open for questions or tips of your own.

I believe that life is too short to do but i thing. In college, I studied Accounting and Finance only continue to scratch my creative itch with my work for Envato Tuts+ and other clients. By day, I enjoy my career in corporate finance, using data and assay to brand decisions. I cover a variety of topics for Tuts+, including photo editing software similar Adobe Lightroom, PowerPoint, Keynote, and more. What I enjoy most is teaching people to utilize software to solve everyday problems, excel in their career, and consummate work efficiently. Experience free to accomplish out to me on my website.

Source: https://business.tutsplus.com/tutorials/how-to-make-professional-charts-in-google-sheets--cms-28453

Berbagi :