Survey Data into pivot & charts

Pivot charts would be an excellent way to visualise this data but the data is not currently in a form which the functionality can work with.

Please see the attachment. I have created a pivot chart to look at the age profile as an example which you can follow for the remaining types of data.

the steps are ....

• Give a new tab an appropriate unique name.
• Create a copy of the sub in module1 below the existing one, give it an appropriate name and change the ranges on which it operates.
• Run the sub.
• Use the data on the new tab to create the pivot chart

Please Login or Register  to view this content.