creating a chart

**themagicman** · 07-13-2008, 01:29 PM

I would really need some help with the following problem: I am trying to create a chart which should look like the as the one attached.

My values are:
Very important 40
Important 20
Neutral 20
Less important 15
Unimportant 5

Is it possible to create a graph like the one attached? I know that I have to make Less important (15) and unimportant (5) negative - but what about neutral? It should actually by "cut by half" - but I cannot find any solution for this?

Any help?

**Andy Pope** · 07-14-2008, 04:21 AM

You will need to recalculate your values in order to create a positive and negative Neutral score.

And include 2 more series in order to plot the correct Value data label .

**themagicman** · 07-14-2008, 09:41 AM

Thats it! Thank you very much for your help!

**pmembrey** · 07-03-2010, 01:58 AM

Hi,

Any chance you can explain the logic behind this? i.e. how did you go about creating it? I'd love to use it for my current project, but I want to make sure I understand how / what it is you're doing first :-)

Thanks in advance!!

Cheers...

**Andy Pope** · 07-03-2010, 06:48 AM

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.

Please take note of this for future posts.

Create a stacked bar chart on all series in range A8:G16
move last 2 series to secondary axis.
Format those 2 series to have no fill or border
set the min/max of both primary and secondary value axes
set the category labels to Low

**sisi_011** · 04-09-2012, 04:49 AM

hello,
i have problems regarding descriptive statistics in excel, i would like to know how to analyse 5-point Likert scale questions and finally to make a histogram? for instance if my question is: how you would rate the services offered in Radisson Blu hotel?
Answers: Very good - 13, Good - 18, Average - 5, Poor - 6, Very poor - 8

i would be very grateful if someone can help me