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

Return to Full Article

Search
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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
Ask a Question

      Return to Full Article