creating a pie chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when i select the text that i want to create the pie chart from and i click
on insert, chart, and i select the pie chart, it just shows me a line instead
of the pie chart.
Can someone please help me
 
Hi,

Excel will not automatically summarize you textual values.
For example if your data, in A1:A6, was;

Apple
Orange
Orange
Orange
Apple
Apple

you would not get a 2 slice pie chart with each slice being 50%. You
need to summarize the data using formula or pivot table. The create the
pie chart on the summary data.

Here is an example of summarizing the example data.
B1: ="Apple" C1: =COUNTIF($A$1:$A$6,B1)
B2: ="Orange" C2: =COUNTIF($A$1:$A$6,B2)

The select B1:C2 in order to create your chart

Cheers
Andy
 
Back
Top