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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"all4adav" wrote in message
...
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.