# [SOLVED] basket with fruits : numbers and formula

1. ## [SOLVED] basket with fruits : numbers and formula

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

2. ## Re: basket with fruits : numbers and formula

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.

rbus wrote:
> 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
>
>

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

3. ## Re: basket with fruits : numbers and formula

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 !!

"Debra Dalgleish" <dsd@contexturesXSPAM.com> a écrit dans le message de
news: 41EC6888.6000102@contexturesXSPAM.com...
> 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.
>
> rbus wrote:
>> 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

>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

4. ## Re: basket with fruits : numbers and formula

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

rbus wrote:
> 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 !!
>
> "Debra Dalgleish" <dsd@contexturesXSPAM.com> a écrit dans le message de
> news: 41EC6888.6000102@contexturesXSPAM.com...
>
>>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.
>>
>>rbus wrote:
>>
>>>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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

5. ## Re: basket with fruits : numbers and formula

Hello Debra !
Many thanks for your help it worked !!
See you.
rb

"Debra Dalgleish" <dsd@contexturesXSPAM.com> a écrit dans le message de
news: 41ED0C1C.1030306@contexturesXSPAM.com...
> 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
>
> rbus wrote:
>> 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 !!
>>
>> "Debra Dalgleish" <dsd@contexturesXSPAM.com> a écrit dans le message de
>> news: 41EC6888.6000102@contexturesXSPAM.com...
>>
>>>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.
>>>
>>>rbus wrote:
>>>
>>>>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

>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1