basket with fruits : numbers and formula

  • Thread starter Thread starter rbus
  • Start date Start date
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
 
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.
 
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 !!
 
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
 
Back
Top