A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Stacked bar chart for survey results (agree/disagree)



 
 
Thread Tools Display Modes
  #1  
Old October 2nd 07, 03:55 PM posted to microsoft.public.excel.charting
CST
external usenet poster
 
Posts: 1
Default Stacked bar chart for survey results (agree/disagree)

I have survey results with answers from strongly agree to strongly disagree.
I would like to show the results for each question in a stacked bar chart.
The first bar (left) shows the strongly agree and agree together with the %
of overall responses above the bar(for both categories combined). The second
would be the neutral answers with the percent above. the third bar would have
disagree and strongly disagree with the % above it.

The point is that if our statement is "22% strongly agree or agree" then it
is obvious from the chart.
thanks for any suggestions.
Ads
  #2  
Old October 2nd 07, 05:20 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 6,582
Default Stacked bar chart for survey results (agree/disagree)

You need four columns. Leftmost lists the questions, then in the next three
columns put your combined percentages for strongly agree and agree, neutral,
and disagree and strongly disagree. Put headers in the top row above the
data, but don't put a label above the list of questions.

Select the data, create a stacked bar chart. When it's made, double click
the vertical axis (the X axis) and on the Scale tab, check Categories in
Reverse Order and Value Axis Crosses At Maximum Category. Go to Chart menu >
Chart Options, and on the Data Labels tab, choose Values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"CST" > wrote in message
...
>I have survey results with answers from strongly agree to strongly
>disagree.
> I would like to show the results for each question in a stacked bar chart.
> The first bar (left) shows the strongly agree and agree together with the
> %
> of overall responses above the bar(for both categories combined). The
> second
> would be the neutral answers with the percent above. the third bar would
> have
> disagree and strongly disagree with the % above it.
>
> The point is that if our statement is "22% strongly agree or agree" then
> it
> is obvious from the chart.
> thanks for any suggestions.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
tallying survey results marcietmp Excel Discussion (Misc queries) 2 September 12th 07 07:11 PM
Finding Top Two Survey Results Brian H Excel Worksheet Functions 7 February 25th 07 12:35 AM
Survey Results help Curt1521 Excel Worksheet Functions 1 December 18th 06 11:16 PM
survey results [email protected] Excel Worksheet Functions 1 December 5th 06 11:21 PM
Tabulating Survey Results Tabulatin Survey results Excel Discussion (Misc queries) 3 December 13th 04 09:56 PM


All times are GMT +1. The time now is 02:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.