Link to home
Start Free TrialLog in
Avatar of Andrew
AndrewFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel graphing

Would it be possible to display the data in the 'output' sheet from question:
Do you have a disability: (as defined under the Disability Discrimination Act)


in graphical format on the 'Charts' sheet
Survey-Monkey-Trial-V6.xls
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

You need it in a new Chart sheet or following the other charts ?
gowflow
Avatar of Andrew

ASKER

Following the others please, 3 to a page?

Andy
ok let me look at this first thing 2morrrow
gowflow
Hey! I made a few different versions of the chart in the chart sheet pending which style you like. Take a look!
Survey-Monkey-Trial-V6-samrad.xls
@samrad1
Just to understand, you did this thru macro or simply designed them manually ?
gowflow
andymacf
Pls check out this version and let me know if this is what your looking for. Create Output has been also modified to cater for this new graph possibility.

gowflow
Survey-Monkey-Trial-V7.xls
Avatar of Andrew

ASKER

Hi @samrad1

Thank you for your input, I cannot see how you have achieved this output.

Andy
Avatar of Andrew

ASKER

Hi gowflow

I have imported a new set of data as the previous set was not particularly helpful as it was mostly all teh same choices.  I upload the file for you here, it seems there is an issue with the transition from import to output.  The 'new' data is not displaying in the correct format in Col A and this is having a knock-on to the other columns.

Andy
Copy-of-Survey-Monkey-Trial-V7.xls
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Andrew

ASKER

Yet again, you have helped me immensely to obtain a working model for the issues I had.

Thanks again
Andy
My pleasure. Feel free to let me know for any future help needed. I will keep this question opened for you to advise.
gowflow
Avatar of Andrew

ASKER

Hi gowflow

I have opened a new question on this topic, Comments

Hope you can help?

Thanks Andy