Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

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
0
andymacf
Asked:
andymacf
  • 6
  • 5
1 Solution
 
gowflowCommented:
You need it in a new Chart sheet or following the other charts ?
gowflow
0
 
andymacfAuthor Commented:
Following the others please, 3 to a page?

Andy
0
 
gowflowCommented:
ok let me look at this first thing 2morrrow
gowflow
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
samrad1Commented:
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
0
 
gowflowCommented:
@samrad1
Just to understand, you did this thru macro or simply designed them manually ?
gowflow
0
 
gowflowCommented:
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
0
 
andymacfAuthor Commented:
Hi @samrad1

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

Andy
0
 
andymacfAuthor Commented:
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
0
 
gowflowCommented:
Yes for sure as the model I posted was based on the first assumption of Column DU and was not changed when you mentioned the first Question of the new Survey being always
Do you have a disability ...

Sorry an oversight of me.

Here is it fixed in this version.
gowflow
Survey-Monkey-Trial-V8.xls
0
 
andymacfAuthor Commented:
Yet again, you have helped me immensely to obtain a working model for the issues I had.

Thanks again
Andy
0
 
gowflowCommented:
My pleasure. Feel free to let me know for any future help needed. I will keep this question opened for you to advise.
gowflow
0
 
andymacfAuthor Commented:
Hi gowflow

I have opened a new question on this topic, Comments

Hope you can help?

Thanks Andy
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now