Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Entering data from surveys to create charts

Resolved · Medium Priority · Version 2007

Reply Thu 14 Jul 2011, 16:30Delegate paul said...

paul has attended:
Excel Intermediate course

Entering data from surveys to create charts

no specific question but more information on this would be great

For upcoming training course dates see: Pricing & availability

Reply Fri 15 Jul 2011, 14:50Trainer Simon said...

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 articles

· Correct In, Garbage Out
· Don't Get Lost In A Sea Of Data, Use Excel Navigation
· How To Use The Research Functionality In Excel 2010
· Sorting Out Your Data In Excel
· Prepare for your MOS Certification with MS Excel Courses

Please browse our web site to find out more about
2002 excel microsoft training and other Microsoft training courses.

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips