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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top