Table to Graph - need some help.

Question

Table to Graph - need some help.

Hello all,

Here is my issue. Imagine you have data concerning quantities of various types of fruit. In column A you have navel oranges, Valencia oranges, red delicious apples, rome apples, fuji apples, etc.. In column B you have the quantities for each variety of fruit. Now say that you want to have a pie chart that represents your data. Is there a way to make the pie chart represent just apples and oranges, rather than every variety of apple and orange?

Thanks.

Various, Mac OS X (10.6.5)

Posted on Nov 20, 2010 9:36 PM

Reply

Answer 1

Barry

Level 9

59,975 points

Nov 20, 2010 11:53 PM in response to Captain Spalding

Hello...

Add two Footer rows to your table. In the first enter "Apples" in column A, in the second enter "Oranges" in column A.
In column B of the first footer row, enter =SUMIF($A," appl",$B)
In column B of the second footer row, enter =SUMIF($A," orang",$B)

Select the two cells containing the formulas. Choose the pie chart from the chart button's menu. Click on each wedge and choose a more appropriate fill colour. 😉
Done.

...I must be going.

Regards,
Barry

Reply

Answer 2

Nov 21, 2010 10:40 AM in response to Barry

Thanks, Barry. Worked like a charm.

Reply