Q&A for How to Create a Graph in Google Sheets

Return to Full Article

Coming soon

Add New Question

Question

How would I make a pie chart?

Community Answer

Right click on your chart, click chart style, then scroll down until you find the chart type that you want.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 27 Helpful 27
Question

I 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 Answer

Hold down "Control" for Windows and "Command" for Mac, then try selecting your columns.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 31 Helpful 23
Question

How do I transfer my graph onto Google Sheets?

Community Answer

Share it, and also copy and paste it. Then it will immediately go to Google Sheets.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 27 Helpful 12
Question

How do I make my data appear in the chart after selecting columns and clicking 'Chart' but seeing 'no data'?

Mr c

Top Answerer

If your chart in Google Sheets isn't showing data, check the data range, ensure the correct chart type is selected, verify data formatting, review chart settings, and try refreshing the page or reopening the document.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

Why does my chart say 'no data'?

Mr c

Top Answerer

Check the data range, be sure the correct chart type is selected, verify data formatting, review chart settings, and try refreshing the page or reopening the document.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

How do I create a graph with one line using two sets of data, where one set determines the x-axis and the other the y-axis?

Mr c

Top Answerer

To create a graph with one line and two sets of data in Google Sheets, enter your data in two columns, highlight both, go to "Insert" > "Chart," choose the chart type, and customize it as needed. This will generate a graph with your specified data on the x-axis and y-axis.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

How can I fix a chart in Google Sheets that shows no data after following all the steps?

Mr c

Top Answerer

If your chart in Google Sheets isn't displaying data, check the data range, ensure the correct chart type is selected, verify data formatting, review chart settings, and try refreshing the page or reopening the document.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

Why won't my chart in Google Sheets show data?

Mr c

Top Answerer

If your chart in Google Sheets isn't showing data, check the data range, ensure the correct chart type is selected, verify data formatting, review chart settings, and try refreshing the page or reopening the document.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

Why can't I produce a chart after converting data from a Google Spreadsheet?

Shefa Begum

Community Answer

Ensure your data is formatted correctly, with a header row and organized columns. Double-check your selected data range to include all relevant information.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

What should I do if it says 'no data' in Google Sheets when creating a graph?

Harithapuram

Community Answer

This could be a permissions error with your service account. Try running other actions to see if you encounter similar issues, which can help identify if permissions are the cause.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

How do I create a graph with two columns in Google Sheets?

StoneBlaze

Community Answer

Select the box next to the first column title, give it a name, and then fill in the information.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

How do I make a box plot?

Warren

Top Answerer

Highlight the cells containing the data you'd like to include. Then select the 'Insert' button. Then select the 'Chart' option from the dropdown menu. Select the 'box plot' option in the chart editor.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

If the chart isn't working, what do I do?

Tina X

Community Answer

Try refreshing the page, or insert a new chart. You can customize it after the data is entered. Or, try to create a new spreadsheet.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 5 Helpful 1
Question

How do I paste my graph into Google Docs?

Tina X

Community Answer

You can first copy your graph from Google Sheets. Then, paste it onto Google Docs. You can insert a link, or insert the graph. Google Docs would give you two options.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 3
Question

How do I create a key for a graph in Google Sheets?

Community Answer

Under the customize tab, there is a dropdown option called "legend". This is the same thing as a key and you should be able to customize it however you want.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 2
Question

How do I put the title on my graph in Google Sheets?

Community Answer

Click the three dots at the top right corner of the graph. Click the "Customize" tab, then "Chart & axis titles". Type your title in the "Title text" box.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 5 Helpful 2
Question

How do I add a specific point on the already plotted graph?

Community Answer

You have to go back to the original data and add a point. You can create the graph then.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 5
Question

How can I copy and paste only the graph?

Community Answer

Click on the picture, then do (Command Key on Mac) Ctrl + C to copy, then to paste do Ctrl + V.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 4 Helpful 11