+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    10-23-2009
    Location
    Sarasota, Florida
    MS-Off Ver
    Excel 2007
    Posts
    30

    Graphing strings in a pie chart

    Ok this is a simple one.

    How do I graph letters onto a pie chart.

    For example, I have 5 cells, 2 have the letter "A" in them, 2 have the letter "B" in them, and 1 has the letter "C" in it.

    I want to make a pie chart that shows how many of each letter I have.

  2. #2
    Forum Contributor
    Join Date
    04-03-2007
    Location
    Auckland, New Zealand
    MS-Off Ver
    2007
    Posts
    137

    Re: Graphing strings in a pie chart

    Hi,

    Not sure you can chart strings.

    The easiest way I can think of to get the result you want (charting the number of occurrences of each letter) is to count them and chart the counts.

    The attached may help
    Attached Files Attached Files

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.2.0