+ Reply to Thread
Results 1 to 6 of 6

how do i make a chart using text information?

  1. #1
    danielle
    Guest

    how do i make a chart using text information?

    I'm trying to make a pie chart using words as the information to compute =

    rather than numbers - is this possible to do? like for example if i =
    wanted to=20
    calculate the percentage of french students, spanish students, and =
    english=20
    students in a class of 30, and i set up my column like this:

    STUDENT'S NATIONALITY
    french
    french
    english
    spanish
    english
    spanish
    spanish
    spanish
    french
    .....

    would it be possible to have excel make a pie chart that shows the=20
    proportion of french to english to spanish students in the class? or do =
    i have=20
    to set up my information differently?

    -danielle

  2. #2
    Roger Govier
    Guest

    Re: how do i make a chart using text information?

    Hi Danielle

    Insert a row at the head of your data and call it Nationality.
    Mark the whole block of data and select Data=>Pivot Table and finish
    Drag the field Nationality to the Row Area and also to the Data Area
    selecting Count of Nationality.
    Slect Pivot Chart and the data will be expressed as a pie chart as you
    require.

    For more detailed instructions on setting up Pivot Tables and Charts take a
    look at the examples at Debra Dalgleish's site
    http://www.contextures.com/tiptech.html and in particular follow the link to
    http://peltiertech.com/Excel/Pivots/pivotstart.htm

    --
    Regards
    Roger Govier
    "danielle" <anonymous@discussions.microsoft.com> wrote in message
    news:1baf01c51c37$5488fd10$a401280a@phx.gbl...
    I'm trying to make a pie chart using words as the information to compute
    rather than numbers - is this possible to do? like for example if i wanted
    to
    calculate the percentage of french students, spanish students, and english
    students in a class of 30, and i set up my column like this:

    STUDENT'S NATIONALITY
    french
    french
    english
    spanish
    english
    spanish
    spanish
    spanish
    french
    .....

    would it be possible to have excel make a pie chart that shows the
    proportion of french to english to spanish students in the class? or do i
    have
    to set up my information differently?

    -danielle



  3. #3
    Arvi Laanemets
    Guest

    Re: how do i make a chart using text information?

    Hi

    Define a dynamic range p.e. Nationality, as:
    =OFFSET(Sheet1!$A$2,,,COUNTIF(Sheet1!$A:$A,"<>")-1,1)

    (I assume in A1 is column header, so actual data start from A2)

    Create another table on another or on same (as in my example) sheet, p.e.
    F1="Nationality";
    G1="Number";
    F2:F4 enter "french", "english" and "spanish";
    Into G2 enter the formula
    =COUNTIF(Nationality;F2)
    and copy it to range G2:G4;
    Create your pie chart based on this new table.


    Arvi Laanemets


    "danielle" <anonymous@discussions.microsoft.com> wrote in message
    news:1baf01c51c37$5488fd10$a401280a@phx.gbl...
    I'm trying to make a pie chart using words as the information to compute
    rather than numbers - is this possible to do? like for example if i wanted
    to
    calculate the percentage of french students, spanish students, and english
    students in a class of 30, and i set up my column like this:

    STUDENT'S NATIONALITY
    french
    french
    english
    spanish
    english
    spanish
    spanish
    spanish
    french
    .....

    would it be possible to have excel make a pie chart that shows the
    proportion of french to english to spanish students in the class? or do i
    have
    to set up my information differently?

    -danielle



  4. #4
    RagDyeR
    Guest

    Re: how do i make a chart using text information?

    Arvi,

    I give up ... What does p.e. mean?
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "Arvi Laanemets" <arvilaanemets@hot.ee> wrote in message
    news:%23NEGStDHFHA.588@TK2MSFTNGP15.phx.gbl...
    Hi

    Define a dynamic range p.e. Nationality, as:
    =OFFSET(Sheet1!$A$2,,,COUNTIF(Sheet1!$A:$A,"<>")-1,1)

    (I assume in A1 is column header, so actual data start from A2)

    Create another table on another or on same (as in my example) sheet, p.e.
    F1="Nationality";
    G1="Number";
    F2:F4 enter "french", "english" and "spanish";
    Into G2 enter the formula
    =COUNTIF(Nationality;F2)
    and copy it to range G2:G4;
    Create your pie chart based on this new table.


    Arvi Laanemets


    "danielle" <anonymous@discussions.microsoft.com> wrote in message
    news:1baf01c51c37$5488fd10$a401280a@phx.gbl...
    I'm trying to make a pie chart using words as the information to compute
    rather than numbers - is this possible to do? like for example if i wanted
    to
    calculate the percentage of french students, spanish students, and english
    students in a class of 30, and i set up my column like this:

    STUDENT'S NATIONALITY
    french
    french
    english
    spanish
    english
    spanish
    spanish
    spanish
    french
    .....

    would it be possible to have excel make a pie chart that shows the
    proportion of french to english to spanish students in the class? or do i
    have
    to set up my information differently?

    -danielle




  5. #5
    Arvi Laanemets
    Guest

    Re: how do i make a chart using text information?


    "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
    news:OJj9lCEHFHA.4084@TK2MSFTNGP14.phx.gbl...
    > Arvi,
    >
    > I give up ... What does p.e. mean?



    per example


    Arvi Laanemets



  6. #6
    RagDyeR
    Guest

    Re: how do i make a chart using text information?

    Now why couldn't I figure that out?<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "Arvi Laanemets" <arvilaanemets@hot.ee> wrote in message
    news:%23oIc0eEHFHA.560@TK2MSFTNGP12.phx.gbl...

    "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
    news:OJj9lCEHFHA.4084@TK2MSFTNGP14.phx.gbl...
    > Arvi,
    >
    > I give up ... What does p.e. mean?



    per example


    Arvi Laanemets




+ 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