basket with fruits : numbers and formula

R

rbus

Hello all !
I m back with another pb...
I have a basket with fruits : 5 apples, 2 oranges, 9 tomatoes. Some of them
are ripe, others go rotten...
How to get a chart with :
the number of rotten apples and the number of ripe tomatoes ??
Before trying, I thought it was easy... :)
Thanks for your help !!
rb
 
D

Debra Dalgleish

To create a chart, you could enter the data in columns, e.g.:

Ripe Rotten
apples
oranges
tomatoes

Type the numbers for each category. Then select a cell in the list, and
use the Chart Wizard to create a chart.
 
R

rbus

Hello,
Your solution is good but I don't know how many rotten apples I have :
I have 2 columns : one for the fruit, other for the quality :
apple rotten
tomato rotten
tomato ripe
apple rotten
apple rotten
orange rotten...
So, how to know how many rotten apple I have ?
Thanks !!
 
D

Debra Dalgleish

To summarize the data, you could build a pivot table and pivot chart.
There are instructions and links for pivot tables on Jon Peltier's site:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Add headings to the first row of the list, e.g. Fruit, Condition
Select a cell in the list
Choose Data>PivotTable Report
Click Next, select the list, click Next
Click Layout
Drag the Fruit button to the row area
Drag Condition to the column area
Drag another copy of the Fruit button to the Data area, where it will
become Count of Fruit
Click Next, choose a location for the Pivot Table, click Finish

Select a cell in the pivot table, and click the chart wizard button
 
Top