Creating a single bar chart showing proportional survey results

[Graham_Watson]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hi there. I've conducting a survey using a five point likert rating scale with responses ranging from strongly agree, agree, undecided, agree, strongly agree. Survey's sorted but when I export the data into excel, I would like to represent the data in a condensed, three colored bar chart, indicating - POSITIVE responses (agree/strongly agree), NEUTRAL responses (undecided) and NEGATIVE response (disagree/strongly disagree). I'd like the single bar chart to show proportionally, the responses in a graphical format, so that if only 10% are positive, 60% are undecided and 30% negative, this visually and proportionally represents 10% (green), 60% (yellow) and 30% (Red). I've tried every way I can think of to manipulate the available charts, without success. Any ideas of how I could achieve this. I can send a visual of what I'm looking to achieve if that helps.

Many thanks to anyone who can help.

 

[Laroche J]

Typically, you have to aggregate your values in a table with three rows and
two columns. The first column contains the words POSITIVE, NEUTRAL,
NEGATIVE, while the second column contains the values 10%, 60% and 30% (or
the actual results), which you obtain by various formulas from your
responses.

Finally, select this little table and start the chart wizard, which will
guide you through the different steps to create the chart.

JL
Mac OS X 10.4.11
Office v.X 10.1.9, Office 2008 12.1.7

 

[Shane Devenshire]

Hi,

If you're trying to do this with a single bar, I suggest you follow LJ's
suggestion but choose a stacked column or stacked bar chart type.

However, this kind of data lends itseft to a pie chart. Same data layout,
just a different chart type.