+ Reply to Thread
Results 1 to 2 of 2

Graph for these type of data

  1. #1
    Registered User
    Join Date
    06-22-2010
    Location
    Ulm
    MS-Off Ver
    Excel 2003
    Posts
    28

    Graph for these type of data

    Dear all,

    would like to make a graph with informations whose text is of similar length and with these numbers (see below). Now questions is what is the best way to represent these data , having in mind that in half a year comes new data and we want to track the progress (keep new data on the same graph as a benchmark and for comparison purposes) .

    These numbers are actually grades (1-5 survey results)

    In the past the vertical bar chart was used...

    thanks in advance


    XXXXXXXXXXXXXXXXXXXXXX* *2,43
    XXXXXXXXXXXXXXXXXXXXXX 2,86
    XXXXXXXXXXXXXXXXXXXXXX* * *1,71
    XXXXXXXXXXXXXXXXXXXXXX* * *1,86
    XXXXXXXXXXXXXXXXXXXXXX * * *2,86
    XXXXXXXXXXXXXXXXXXXXXX 2,14
    XXXXXXXXXXXXXXXXXXXXXX* *2,71
    XXXXXXXXXXXXXXXXXXXXXX 1,71
    XXXXXX 2,00
    XXXXXX *2,43
    XXXXXX* *2,43
    XXXXXXXXXXXXXXXXXXXXXX 2,71
    XXXXXXXXXXXXXXXXXXXXXX* *2,29
    XXXXXXXXXXXXXXXXXXXXXX * 3,29
    XXXXXXXXXXXXXXXXXXXXXX 2,80
    XXXXXXXXXXXXXXXXXXXXXX *2,86
    XXXXXXXXXXXXXXXXXXXXXX * * *2,86
    XXXXXXXXXXXXXXXXXXXXXX 1,86
    XXXXXXXXXXXXXXXXXXXXXX 2,00
    XXXXXX* * * 2,17
    XXXXXX* 2,57
    XXXXXX** * *1,86
    XXXXXX** * *2,71
    XXXXXX* 1,86
    XXXXXX* * 1,71
    XXXXXX** 1,86
    XXXXXX* 2,33

  2. #2
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: Graph for these type of data

    I have no idea what your data contains. I assume the strings of XXXX are labels. Are all labels in each apparent block the same? What are the asterixes between the labels and the numbers?
    Jon Peltier
    http://PeltierTech.com/

+ 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