Q&A for How to Make a Pie Chart in Excel

Return to Full Article

Coming soon

Add New Question

Question

How do I create a pie chart without percentages?

Community Answer

You'll have to make percentages. A pie chart by definition is 100%. If your data is not in percent, then Excel will create percentages for you.

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 39 Helpful 53
Question

How do I change the color of the pie chart?

Community Answer

Once you have the pie chart on the board, there are different shades next to it that says "change color"; click on that.

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 16 Helpful 19
Question

What am I doing wrong if I tried this method and the pie chart didn't show up?

Community Answer

You might have entered information wrongly and it can't process. Try re-entering your data.

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 49 Helpful 39
Question

How do I label the pie chart?

Community Answer

Look for a section that says Chart Elements while the graph is selected. Once there, use either data labels and/or the legend to add whatever labels you need. I would recommend tinkering with these options to see what you could use.

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 7
Question

How do I easily create a table from the data on the dashboard?

Community Answer

Go to one of the top tabs, and on one it says "charts" then click on it, and it will say Pie Chart.

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 16 Helpful 8
Question

How can I add an existing pie chart?

Community Answer

I would recommend saving the pie chart as an image, navigating to the Insert tab in Excel, and inserting your pie chart as an image.

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 4
Question

How can I export a pie chart from Excel to Microsoft Publisher?

Community Answer

Select the chart by clicking in the center of it, press Ctrl (on your keyboard), and while that key is down, press C. Now open up your Microsoft Word and press Ctrl V (that means press Ctrl and meanwhile its down, press V). Your chart should show up, but the colors may be different.

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 2 Helpful 2
Question

How do I combine several common allocations to one total value in a pie chart?

Community Answer

Your data first has to be in percentages. Then click the chart and it will automatically calculate it for you.

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 my pie chart white only in Excel?

Community Answer

Click the pie chart and go to the design tab. After you click the design tab, go to colors and you should be able to change the color of your pie chart.

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 2 Helpful 0