1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need Some Help With Microsoft Excel and Google Spreadsheet...

Discussion in 'BlackHat Lounge' started by LOL-Blaster, Jan 15, 2013.

  1. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    I am using google spreadsheet to gather survey data:
    The spreadsheet looks like this

    Code:
    Timestamp            Choice    Comment
    1/15/2013 4:24:29    A         Comment goes here
    1/15/2013 4:24:32    B    
    1/15/2013 4:24:37    A    
    1/15/2013 4:24:40    B    
    1/15/2013 4:24:44    A    
    1/15/2013 4:24:48    A    
    1/15/2013 4:24:53    A    
    Is there any way to compile the information and
    create a line graph to display the trend of A and B over time?
     
    Last edited: Jan 15, 2013
  2. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    Bump for answer.
     
  3. portalweb

    portalweb Supreme Member Premium Member

    Joined:
    Jan 7, 2010
    Messages:
    1,415
    Likes Received:
    547
    Occupation:
    Hard Core Engineer
    Location:
    New York
    1) Replace A with 1, B with 2, C with 3 as it's easier to use numbers.
    2) X for Timestamp, Y for Choice.
    3) Plot X and Y

    Pretty simple.
     
  4. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    Can you elaborate it further?
    I am using excel 2010
     
  5. portalweb

    portalweb Supreme Member Premium Member

    Joined:
    Jan 7, 2010
    Messages:
    1,415
    Likes Received:
    547
    Occupation:
    Hard Core Engineer
    Location:
    New York
    Hi,

    Do you have "Create Chart" button added to your Quick Access Toolbar? If not, click on MS Office button (top left button), select Excel Options, add "Create Chart" that will add "Create Chart" icon on the top left mini-menu "Quick Access" toolbar.

    1) Then, select TimeStamp cells (column only) to use hh:mm:ss am/pm format
    2) Highlight TimeStamp/Choice (see screenshot below)
    3) Click Create Chart, select Bar Chart, then click OK button.

    Presto...an easy to read bar chart.

    Remember, experiment...and use F1 key as your best friend.

    Have fun!

    Screenshots
    [​IMG]

    [​IMG]
     
    Last edited: Jan 15, 2013
  6. LOL-Blaster

    LOL-Blaster Regular Member

    Joined:
    Aug 29, 2012
    Messages:
    342
    Likes Received:
    706
    That's not what I am looking for at all.
    A and B are just example, they are options in a multiple choice questions on my spreadsheet.

    Thanks anyway.