Forum Statistics
- Forum Members:
- Total Threads:
- Total Posts: 14
There are 1 users currently browsing forums.
|
 |
07-18-2008, 05:25 AM
|
|
Registered User
|
|
Join Date: 13 Jul 2008
Location: Austria
Posts: 9
|
|
|
Charting a Likert-Scale, part II
Please Register to Remove these Ads
First I would like to say thank you for the great help I received from this forum, especially from Andy Pope. I dont know why my thread from July 7 is not here any more, but anyway - the answer I received was of great help.
The last time I had problems with presenting the results of a Likert-Scale in a graph, showing values for such things as Very important, Important, Neutral etc. Now I know how to "cut" the "neutral" by half - but if I want to show the results of two different likert-scales side-by-side in a graph (please see the attached sheet), I get a different picture.
Could anyone help me with this problem?
|
07-18-2008, 06:56 AM
|
 |
Forum Guru
|
|
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
|
|
Because you are already using the secondary axis for the pad and neutral series the second set of data is using the wrong scale.
Just keep your data in a single table.
Your other post is still available
http://www.excelforum.com/excel-charting/649678-creating-a-chart.html
|
07-18-2008, 07:22 AM
|
|
Registered User
|
|
Join Date: 13 Jul 2008
Location: Austria
Posts: 9
|
|
Woah. Thanks again. I think it will take some time until I get the whole picture...
One final thing: When I flip the graph and the bars are vertical - the label for "neutral" disappears (see attached file) ... and I cannot bring it back. Any ideas?
|
07-18-2008, 07:32 AM
|
|
Forum Guru
|
|
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
|
|
|
That is because you have not moved the neutral or pad series to the secondary axis.
You will need to move both series and then change the chart type to Stacked column.
Also adjust the seconady value axis to have Min=0 Max=200
|
07-18-2008, 08:23 AM
|
|
Registered User
|
|
Join Date: 13 Jul 2008
Location: Austria
Posts: 9
|
|
|
Thanks!
Regarding the graph with the two sets of data: when you put all the data (from two series) in one table, the bars are all looking like the same (colour-wise; despite from the fact that they can also have different labels.) If I want to have the bars of the first series in blue and the second series in orange, I have to colour every single bar of one of the series seperately (as they are in one table with one set of labels - they all have the same colour).
I guess, there is no solution for this.
Cheers from Vienna!
|
07-18-2008, 08:57 AM
|
|
Forum Guru
|
|
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
|
|
|
Change the layout of your data.
|
07-18-2008, 09:21 AM
|
|
Registered User
|
|
Join Date: 13 Jul 2008
Location: Austria
Posts: 9
|
|
|
This is just super - exactly what I was looking for. Thank you.
Do you have any suggestions what to do with the legend? The current legend cannot be posted somewhere in the graph - it is totally misleading. Is it possible to create a "fake legend" which shows the correct colours/descriptions?
|
07-18-2008, 09:50 AM
|
|
Registered User
|
|
Join Date: 13 Jul 2008
Location: Austria
Posts: 9
|
|
|
But in my case, you have two series in one graph with TWO DIFFERENT labels.
For example:
Very important, Important, Neutral, etc. vs.ver
Very satisfied, Fairly satisfied, Neutral, etc.
(see above: 650293a.xls)
My problem is then to create the correct sequence:
Not: X Unimportant X Less important X Neutral X Very Important ...
But: X Very important X Important X Neutral ....
|
07-18-2008, 09:53 AM
|
|
Forum Guru
|
|
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
|
|
|
Then add additional series that have the correct names in the correct sequence.
No need for this series to be displayed on the chart, only in the legend.
Or use another chart along side this complex one which you simply use dummy data in order to get the required legend.
|
07-18-2008, 10:00 AM
|
|
Registered User
|
|
Join Date: 13 Jul 2008
Location: Austria
Posts: 9
|
|
|
... I am going to try this. But I gotta go now - thank you for your great support.
Cheers,
|
07-18-2008, 02:16 PM
|
|
Forum Guru
|
|
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
|
|
|
Here is the last chart with additional series used to create a legend.
|
07-02-2009, 10:26 AM
|
|
Registered User
|
|
Join Date: 02 Jul 2009
Location: Ithaca, USA
MS Office Version:Excel 2007
Posts: 1
|
|
|
Re: Charting a Likert-Scale, part II
Where do I find a chart template that looks like this. I am also trying to chart a Likert scale.
|
07-02-2009, 04:06 PM
|
 |
Forum Guru
|
|
Join Date: 20 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 18,543
|
|
|
Re: Charting a Likert-Scale, part II
Please take a few minutes to read the forum rules, and then start your own thread.
__________________
Entia non sunt multiplicanda sine necessitate.
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
