building graphs data we

TrustPilot

starstarstarstarstar Excellent

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Building Graphs from data we have from a Word Document

Building Graphs from data we have from a Word Document

resolvedResolved · High Priority · Version 2016

Wed 12 Jun 2019, 09:14 replyReply Delegate Katie said...

Katie has attended:
Excel Introduction course
Excel Intermediate course

Building Graphs from data we have from a Word Document

Good morning,

I currently work in HR and we complete our exit interviews on a word document with certain tick boxes for the individual to carry out.

My Manager has asked if there is a way of collating the information from the word document and putting it into an excel spreadsheet in graphs so we can look at averages of the answers of what people are agreeing or disagreeing on the same things?

I have the document to show you if that helps?

I look forward to hearing from you.

Kind regards,

Katie

For upcoming training course dates see: Pricing & availability

Wed 12 Jun 2019, 19:50 replyReply Trainer Jens said...

RE: Building Graphs from data we have from a Word Document

Hi Katie,


Thank you for the forum question.

Yes I would like to see the word document.

To me it sound like it need to be VBA coded, but let me have a look at it, and when I get the document it will be clear, how it can be done.

Please send the Word document to:

info@stl-training.co.uk


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0845 5194 797
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 13 Jun 2019, 22:15 replyReply Trainer Jens said...

RE: Building Graphs from data we have from a Word Document

Hi Katie,

Thank you for the file.

As I assumed it can only be done by VBA coding and it takes a advanced level of VBA skills to do it.

If the goal is to automate a report from the questionnaires with charts and statistics, it is easier if the form is created in Excel or as a form in a database. If you have a 365 account Microsoft has created a form tool, which will collect the answers from the form and display the result in a report without any work to do. Well you need to create the form and design the report, but after the process will be totally automated.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0845 5194 797
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 17 Jun 2019, 10:55 replyReply Delegate Katie said...

RE: Building Graphs from data we have from a Word Document

Hi Jen,

Thank you for your reply.

If we do not have any colleagues that are able to help with the VBA Coding, is there a step by step guide that would be able to help us collate this information to do so?

I look forward to hearing from you.

Kind regards,

Katie

Mon 17 Jun 2019, 12:52 replyReply Trainer Jens said...

RE: Building Graphs from data we have from a Word Document

Hi Katie,


As I mentioned it takes advanced level of VBA knowledge to do this.

You can Google and find a lot, but it will not help you if you do not have VBA experience.


You will need a folder picker, you will need to loop through all the questionnaires in the folder, you will need to loop through all the form controls in the Word documents, you will need to transfer the answers to an Excel table, and much more.

https://stackoverflow.com/questions/3344649/how-to-loop-through-all-controls-in-a-form-including-controls-in-a-subform-ac


https://stackoverflow.com/questions/11526577/loop-through-all-word-files-in-directory

https://stackoverflow.com/questions/41011932/transfer-data-from-word-to-excel-via-vba

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0845 5194 797
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector


 

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


TrustPilot
TrustScore 4.8 / 5       1157 reviews