Solved

Excel graphing

Posted on 2013-11-18
11
137 Views
Last Modified: 2013-11-19
Hi experts

Further to a problem a while ago, the content of my csv files has had to change and I was hoping that someone could help me reconfigure the graphical output from these csv files.  The final output of my previous question, Previous question output

I attach a csv file which includes a sample of the new outputs

Andy
Sheet-1.csv
0
Comment
Question by:andymacf
  • 6
  • 5
11 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 39658648
Hello,

I noticed that the new survey starts at Column DV and the format in Row 2 for this new survey is different from the previous

Previous is every 4 we get a question with measure and hyphen "-" separate question from the measure.
New one starts at Column DV number of measure is variable and we do not have a question only the topic (row1) is the question and there is no hyphen only a measure in row2

To be able to design something that would encompass the 2 (being totally different) I need a confirmation at least that previous will end at Col DU and new one will always start at col DV and format for previous will remain unchanged and format of new one will remain unchanged

... at least for now to be able to provide you with a solution..
gowflow
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39658724
Hi andymacf,

I fixed for you the 2 options
Import Data
You can choose between xls or csv to import and it import successfully the new format.

Create Output
It will import all data imported in sheet Import based on the previous assumption I posted which is Col DU (on the raw data) is the last column of old survey and Col DV is the first Col of new survey.

Try the attached file and let me know your comments.
gowflow
Survey-Monkey-Trial-V5.xls
0
 
LVL 7

Author Comment

by:andymacf
ID: 39659309
Hi gowflow

Been a busy morning, so not been able to look at this until now.  Unfortunately, the first column of the new items is not always the same as different surveys have differing amounts of questions thus the ending column of the old part will not always be DU, meaning that the start column of the new items will also change.

regards
Andy
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 29

Expert Comment

by:gowflow
ID: 39659770
Ok do you at least know what is the first item label of the new survey ??
I need to know 2 things

1) Will always you have old survey then new survey
2) if answer to 1 is yes then need anything that can tell me what is the start of new survey like is it the same first question or a column or. .. ???

gowflow
0
 
LVL 7

Author Comment

by:andymacf
ID: 39659944
1. Yes
2. The first question in the new part will always be:
Do you have a disability: (as defined under the Disability Discrimination Act)

The answer being either 'Yes' or 'No'

Thanks
Andy
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39660218
ok fine did you try the file I posted is it ok ?
gowflow
0
 
LVL 7

Author Comment

by:andymacf
ID: 39660261
Hi gowflow

Thank you, I have just had a look at the file, this separates out the data nicely although there seems to be something amiss with the first 'new' question, it is totalling correctly on 'Import' but these totals are not showing correctly on 'Output'.

Would you also be able to display the 'new' data graphically?

Thanks again
Andy
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39660893
You are correct for the totals they have been corrected in this version.
Pls try it out and let me know.

As far as the graph, I think this should be object of a new question altogether as graphs when data is not identical ... ??? will need to look at this.

gowflow
Survey-Monkey-Trial-V6.xls
0
 
LVL 7

Author Closing Comment

by:andymacf
ID: 39660914
The parameters from a previous question changed and gowflow came to the rescue once again to fix the files for my new requirements.

Thanks again
Andy
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39660919
Glad I could help you. Pls feel free to post a link if you need help with graphic or any other issue.
gowflow
0
 
LVL 7

Author Comment

by:andymacf
ID: 39660937
Herewith a link to a new question, New question for graphs

Thanks gowflow, your help is greatly appreciated
Andy
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question