Pie Chart

  • Thread starter Thread starter all4adav
  • Start date Start date
A

all4adav

I am trying to figure out how to create a pie chart using a group of numbers
without the pie chart interpreting the numbers as their values. For example,
if I select six tens(10) and two twenties(20), how do I get the pie chart to
give me two categories: 3/4 tens; 1/4 twenties. When I try to process these,
it gives me six different categories, proportions being equal to the value of
the number.
 
Hi,

You need to summarize your data and then plot that information.
You could use the Countif function to get the 2 required values.

Cheers
Andy
 
Back
Top