You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: Captain Spalding
Captain Spalding Author
User level: Level 1
0 points

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
2 replies
User profile for user: Barry
Barry
User level: Level 9
59,957 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

Table to Graph - need some help.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up