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

I am using google spreadsheet to gather survey data:
The spreadsheet looks like this


Is there any way to compile the information and
create a line graph to display the trend of A and B over time?

Bump for answer.

LOL-Blaster said:

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?

Click to expand...

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.

portalweb said:

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.

Click to expand...

Can you elaborate it further?
I am using excel 2010

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

portalweb said:

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

Click to expand...

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.