Solved

Excel graphing

Posted on 2013-11-18
11
150 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
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!

 
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

Technology Partners: 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!

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

730 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