CODEWITHSUNDEEP
excelcharts
user3243719
user3243719

Reputation: 21

Is it possible to generate pie chart for a single column based on their values?

My excel spreadsheet is shown below:

enter image description here

I generated pie chart for the GEN column which is shown below.

enter image description here

My problem is that the pie chart is based on the number of rows. I want to get pie chart only for GEN column so that my pie chart shows only the belonging two values (1 and 2) and both occupying 50-50% of the total pie chart area.

Upvotes: 1

Views: 1459

Answers (1)

Noldor130884
Noldor130884

Reputation: 1004

You should select as Y Values of your chart the 1s and the 2s in the interested column separately. Open an empty pie chart and select "choose data", then select "add" and highlight your "1" as a first selection. Hold then Ctrl and select your "2".

Upvotes: 1

Related Questions