Download ArticleDownload ArticleThis article was written by Stan Kats and by How.com.vn staff writer, Darlene Antonelli, MA. Stan Kats is a Professional Technologist and the COO and Chief Technologist for The STG IT Consulting Group in West Hollywood, California. Stan provides comprehensive technology solutions to businesses through managed IT services, and for individuals through his consumer service business, Stan's Tech Garage. Stan holds a BA in International Relations from The University of Southern California. He began his career working in the Fortune 500 IT world. Stan founded his companies to offer an enterprise-level of expertise for small businesses and individuals.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 365,050 times.
Are you trying to create a graph from your data in Google Sheets? A graph is a handy tool because it can visually represent your data and might be easier for some people to understand. This How.com.vn article will teach you how to make a graph (or charts, as Google refers to them) out of data in a Google Sheets spreadsheet using the full desktop browser version.
Steps
Download Article
Go to https://sheets.google.com in your browser. This will open the Google Sheets dashboard if you're logged into your Google account.[1]- If you aren't logged into your Google account, you'll need to enter your email address and password when prompted before continuing.
Click Blank. It's on the upper-left side of the page. Doing so will open a new, blank spreadsheet.- If you have a spreadsheet with data already in it, click it and then skip to the "Select your data" step.
Advertisement
Create your headers. Click cell A1, enter the x-axis label, and then click cell B1 and enter the y-axis label.- If you wanted to document the number of cups of coffee you drink throughout the day, for example, you might put "Hours" in cell A1 and "Cups of Coffee" in cell B1.
- Depending on the type of graph you make, the label placement may vary slightly.
- You can add additional headers in C1, D1, and so on if your graph contains more than two sets of data.
Enter your data. Type your x-axis data into the A column of cells, then type your y-axis data into the B column of cells.- If you have more than two columns of headers to fill, enter information for them as well.
Select your data. Click cell A1, then hold down ⇧ Shift while clicking the bottom cell in the right-most column of data. This will select your entire set of data in blue.
Click Insert. It's a tab near the top-left side of the page. A drop-down menu will appear.
Click Chart. You'll find this option in the middle of the Insert drop-down menu. Clicking it creates a default chart from your data and brings up a window in the center of the page.- You'll also see a "Chart editor" window open on the right side of the page.
Select a chart format. Click the "Chart type" box at the top of the window, then click a chart format in the drop-down box that appears. The chart in the middle of your spreadsheet will change to reflect your selection.[2]- You can click Data range to change the data range that's included in your chart. For example, if you created a new row of data that you'd like to include, click the chart to open the "Chart editor" panel, then click the text field under "Data range" to type in the extra row of data. [3]
- Click the CUSTOMIZE tab at the top of the chart window to change the chart's appearance, labels, and so on.
Community Q&A
- QuestionHow would I make a pie chart?
Community AnswerRight click on your chart, click chart style, then scroll down until you find the chart type that you want. - QuestionI have 5 columns of data, but I want only Column 1 and Column 5. I tried to select all columns and then delete 2-4, but Column 5 DOES NOT appear.
Community AnswerHold down "Control" for Windows and "Command" for Mac, then try selecting your columns. - QuestionHow do I transfer my graph onto Google Sheets?
Community AnswerShare it, and also copy and paste it. Then it will immediately go to Google Sheets.
Video
Tips
- When creating a pie chart, you only need to use one column for numerical data.Thanks
Warnings
- Google Sheets save automatically, but only when you're connected to the Internet. Closing a Google Sheet before it says "Saved" at the top of the page may result in a loss of changes.Thanks
References
- ↑ https://support.google.com/docs/answer/63824?hl=en&co=GENIE.Platform%3DDesktop&oco=0
- ↑ https://support.google.com/docs/answer/63824?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cchange-the-chart-type
- ↑ https://support.google.com/docs/answer/63824?hl=en&co=GENIE.Platform%3DDesktop&oco=0#zippy=%2Cchange-the-data-range
About This Article
1. Go to https://sheets.google.com
2. Click Blank.
3. Enter your graph's data.
4. Select the data.
5. Click Insert.
6. Click Chart.
7. Select a Chart type.
Reader Success Stories
"Thank you, this was awesome. I had to use this for my science fair project."
Did this article help you?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
