entering data surveys create

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Entering data from surveys to create charts | Excel forum

Entering data from surveys to create charts | Excel forum

resolvedResolved · Medium Priority · Version 2007

paul has attended:
Excel Intermediate course

Entering data from surveys to create charts

no specific question but more information on this would be great

RE: entering data from surveys to create charts

Hi Paul,

I hope my last email has given you some food for thought in terms of how to approach graphing survey data.

After doing the CountIf, you can graph each question against the count of each response.

I hope this helps.

Regards

Simon

Fri 22 Jul 2011: Automatically marked as resolved.


 

Excel tip:

Shortcut fill a cell with contents from adjacent cells

Use Control + D to fill a cell with the data from an adjacent cell. This speeds up data entry and is a cool tip to share!


View all Excel hints and tips


Server loaded in 0.09 secs.