+ Reply to Thread
Results 1 to 5 of 5

[SOLVED] basket with fruits : numbers and formula

  1. #1
    rbus
    Guest

    [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. #2
    Debra Dalgleish
    Guest

    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. #3
    rbus
    Guest

    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" <[email protected]> a écrit dans le message de
    news: [email protected]...
    > 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. #4
    Debra Dalgleish
    Guest

    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" <[email protected]> a écrit dans le message de
    > news: [email protected]...
    >
    >>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. #5
    rbus
    Guest

    Re: basket with fruits : numbers and formula

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

    "Debra Dalgleish" <[email protected]> a écrit dans le message de
    news: [email protected]...
    > 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" <[email protected]> a écrit dans le message de
    >> news: [email protected]...
    >>
    >>>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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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