Excel Graphs

What is the question? Your previous question references yet another previous question.

If you want to make it easy for people to help you, please provide the information in this question, so we don't have to go through your question history to figure out what you need.

Please attach a file that shows the data structure you are using. This file may differ from the file you attached to your previous question.

cheers, teylyn

Apologies for that, another expert has provided a solution to my first issue which was to extract data from a csv file and display it in a certain way as indicated on Sheet 'Output'.  The next task is to generate pie charts from this information.  Please see attached file.

Andy
Copy-of-Survey-Monkey-Trial-V3.xls

Hi Teylyn
Hope this msg finds you well. Happens so that I am the other expert who worked on this issue if you feel you want to help further pls let me know so we are not running competition here.
Rgds/gowflow

Hi gowflow, no worries. You keep running with it. It's just a bit easier for other experts to help out if the context resides within the question.

cheers, teylyn

absolutely agree with you. Always good to see you growing higher and higher in EE. Keep it up and good luck.
Best Regards
gowflow

Hi andymacf
Is this what your looking for ?
Just activate macros and after making sure you proceeded with the creation of output with the first question then proceed to activate the graph creation.

Let me know your comments. We can fine-tune of course.
gowflow
Survey-Monkey-Trial-V3.xls

Hi gowflow

This looks great, error occurred when I clicked the Graph button, see attached.  After I closed the VB window, it had created a new sheet called 'Graphs' but there was only a single chart.

Cheers Andy
Error-1.tiff

The original fault for your perusal
Error2.tiff

what excel version are you using ?
gowflow

2010

thought so. the file you posted was .xls so I presumed you had 2003 and developed accordingly.

No problem just comment out these 3 instructions.

'.PlotArea.Top = 80
 '.PlotArea.Height = 135
 '.PlotArea.Width = 135

Select allOpen in new window

Let me know
gowflow

That works fine, whilst we have Office 2010, the office still insist on saving everything as xls, doc, etc.  So, I suppose saving the file as xlsx, I would not need to do anything?

Andy

Oh, I meant to ask, is there a way of forcing the page breaks once you have the graphs?

Andy

note
NO xlsx !!!! but xlsm !

page breaks for sure you want a page break at each start of a topic ? I was going to put that but I said maybe you need some other twiks

let me know
gowflow

Hi gowflow

Would I be able to resize the graphs, if so what would I need to do?  I will need to decide how the page breaks will work as it would be too much to have one set on a page.

Would it also be possible to have a button to import the initial sheet assuming I always name it the same?

Thanks
Andy

Would I be able to resize the graphs

I think this should be object of an other question as feel it need some coding to allow that and it was not part of the initial question.

What do oyu mean by

Would it also be possible to have a button to import the initial sheet

What initial sheet ?
gowflow

In order to get the data, I have to take a filtered csv export from a website, this is my initial file that I copy the data from.

for sure anything can be done no problem if you want you can have a button that is called Import CSV and it will open that csv and read the data into the sheet Import. then you would have the second button create output and then the third create graphs.

Let me know how I can help you further.
gowflow

Hi gowflow

Thanks for the latest post, this is fantastic and I believe we are almost there.

The single page per topic doesn't really work, I feel, with respect to the graphs, it would be a case of 'running on' e.g. continuous printing.  Because of the changing content of differing surveys, it might be more a case of adding page breaks manually as I assume this would be dificult to code.

Also, I do not necessarily want to resize them each time, it is more a case of establishing what is the 'best fit' for printing purposes and setting their size accordingly.  Maybe, if you could point to the areas within the code where I could fiddle with font/graph sizes/margins I could fiddle with them until I get 'best fit'.

Thanks
Andy

no matter what you do with size font the graph height and width are fixed this is why I said it should be worked separately if you want.

At this time I do not have the answer as if I had I would hv incorporated it into the present solution.

gowflow

PAS if you want to remove the present pagebreak just comment out the instruction that has the pagebreak in it.

This is a superb piece of work which aids greatly to streamline one of my processes thus making it easier for my colleagues to produce reports when necessary.  Thank you gowflow for sharing your talent to complete this task.  Your help is greatly appreciated.

Hi gowflow

I have created another question as discussed for the graph resizing, New Question.

Hope you can help?
Andy