Forum Discussion

WendyVN's avatar
WendyVN
Copper Contributor
Oct 18, 2024

Pie Chart

I'm trying to create a pie chart.  It says you only need a single column of data but it is not working.

This is my column of data

Gender
Male
Male
Male
Female
Male
Female
Male
Female
Male
Female
Female
Male
Male
Female
Female
Male
Female
Male
Male
Male
Female
Female
Male
Male
Male
Male
Female
Female
Male
Male
Female
Male
Male
Female
Female
Female
Female
Male
Male
Male
Female
Female
Female
Female
Male
Female
Male
Female
Male
Male
Male
Male
Male
Male
Male
Male
Male
Female
Female
Female
Male
Female
Female
Male
Female
Male
Female
Female
Male
Male
Female
Male
Male
Male
Male
Female
Male
Female
Male
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Male
Male
Female
Male
Female
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Female
Female
Male
Male
Male
Female
Male
Male
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Male
Male
Female
Male
Female
Male
Male
Female
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Female
Female
Male
Male
Male
Female
Female
Female
Male
Male
Male
Female
Female
Male
Male
Male
Male
Female
Male
Male
Male
Female
Male
Male
Female
Male
Female
Female
Female
Male
Male
Male
Male
Female
Female
Female
Male
Male
Female
Male
Male
Male
Female
Male
Male
Female
Female
Female
Male
Male
Male
Female
Male
Male
Female
Male
Male
Male
Male
Male
Female
Male
Female
Male
Female
Female
Male
Male
Female
Female
Female
Male
Female
Male
Male
Male
Male
Female
Male
Male
Male
Female
Male
Male
Female
Male
Female
Female
Female
Male
Male
Male
Male
Male
Male
Female
Female
Female
Female
Female
Male
Male
Female
Male
Male
Male
Female
Male
Female
Male
Female
Male
Female
Male
Male
Male
Male
Female
Male
Male
Male
Female
Male
Male

 

When I select it and right click then go to insert pie chart it gives me this


I have tried going through the select data and changing the data but it's not working either.  I am missing something.  I have selected with the header and without the header.  I managed to get the title to read Gender and the Legend to read  Male   Female but no pie chart.

 

 

Charting

5 Replies

    • WendyVN's avatar
      WendyVN
      Copper Contributor
      Oct 24, 2024

      HansVogelaar 

      Well this is contrary to what MS says you need to do

      Copied and pasted from the help

      Pie and doughnut charts

      Data that's arranged in one column or row on a worksheet can be plotted in a pie chart. Pie charts show the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are shown as a percentage of the whole pie.

       

      Consider using a pie chart when:

      • You have only one data series.
      • None of the values in your data are negative.
      • Almost none of the values in your data are zero values.
      • You have no more than seven categories, all of which represent parts of the whole pie.

      Types of pie charts

      • Pie and 3-D pie    Pie charts show the contribution of each value to a total in a 2-D or 3-D format. You can pull out slices of a pie chart manually to emphasize the slices.

       How to Insert a Pie Chart

      No where in any of this does it say you have to do any calculations or other charts.
      If that is the case then MS needs to correct it's instructions.  Very frustrating and time consuming when you are trying to do something.  

       

       

       

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Oct 24, 2024

        WendyVN 

        Implicit in

         

        • None of the values in your data are negative.
        • Almost none of the values in your data are zero values.

         

        is that the data must be numeric.