Results 1 to 3 of 3

Creating a chart out of text separated by commas

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2012
    Location
    Honolulu, Hawaii
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    2

    Creating a chart out of text separated by commas

    Part of my problem is that I do not have the vocabulary to search for help. So my apologies if I overlooked this exact question in my search.

    I have a online survey I am administering, and one of the questions is "Which upcoming Saturdays are you available? (Check all that apply)"
    the output, which ends up in a single cell is something like this:
    "September 15, September 22, September 29, October 6, October 13, October 20, October 27"

    I am wondering how to easily make a bar chart out of this sort of text data separated by commas.
    The best I have come up with is manually separating them out into their own columns, then using count and charting from that.


    I have attached a sample file.

    Thank you in advance.

    -MC
    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.6.0 RC 1