CODEWITHSUNDEEP
excel
Masteryogurt
Masteryogurt

Reputation: 175

Excel pie chart for one column?

Not sure how frequently excel questions are asked here, but I'm trying to get a pie chart generated for one column of different information, that would display the data in terms of what the visual representation is. For ex Column B titled "food" Different possible entries for the column are Apple Bread Corn Pizza.

I'd like to insert pie chart that shows the visual distribution of how many times there was pizza entered, and corn, and for the others.

Thoughts on formula to do this? Thanks. -wilson

Upvotes: 1

Views: 10827

Answers (1)

teylyn
teylyn

Reputation: 35990

With that many data points, the chart should be a horizontal bar, not a pie. Pie charts are too hard to interpret.

Create a pivot chart, pull the Shape field into the Axis (Categories) area and again into the Values area. enter image description here

Upvotes: 3

Related Questions