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?
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 .
Thats it! Thank you very much for your help!
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...
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks