Charting a likert scale

[pmembrey]

Hi,

I want to create a chart similar to the one in this thread:

http://www.excelforum.com/excel-char...g-a-chart.html

I have seen the instructions for recreating this, but I'm still unsure of the why rather than the how. I know that's not specifically an Excel question, but I would really really appreciate a greater understanding of this particular chart.

Cheers!

[shg]

http://en.wikipedia.org/wiki/Likert_scale

[Andy Pope]

Why would you want to created it if you do not understand the 'why' of it?

The chart is simply centered around the mid point of the Neutral score. In order to do this you need to split the neutral score in to a +/- half and make the negative/very negative scores negative.

[pmembrey]

Hi,

Sorry, I guess I didn't express myself very well. I know why I want to create the graph and what it represents. What I wanted to make sure of was why the particular calculations were used to do it.

Thanks for answering.

Cheers

[Andy Pope]

the calculations are, as I said, to position the segments of each bar around the center of the midpoint of the neutral score.

[Marydavies]

I am really struggling with this type of chart too. Andy popes example has really helped...but what does 'Pad' stand for in the example??

[Andy Pope]

It positions the neutral series in the correct position so the labelling of Neutral is the correct value rather than half positive and half negative.

Simply delete the contents of the Pad cells to see the Neutral data labels shift left.

[Cutter]

Hello Marydavies, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

[Marydavies]

Thanks, thats great!

---------- Post added at 03:15 AM ---------- Previous post was at 03:15 AM ----------

Whoops, sorry!