I would be very grateful if someone could help me with a problem I have displaying both actual values and percentages on the same bar-chart.
We have recently undertaken a small survey and I have to produce some charts showing people's responses. Those above me want both the actual numbers of people who responded in a particular way and the percentage value showing for each question and directorate.
I know how to create a chart with two axes - one with actual values and the other with percentages - but, because I'm displaying the results of several questions on one chart, the actual number and its associated percentage don't follow the same relationship for every question. Is this clear or am I talking gibberish?
Can anyone explain how I might create a bar-graph which performs the requirements shown above and on which I can show both actual values and percentages for each bar?
Many thanks for fighting your way through this far and double thanks in advance to anyone who can help.
Regards,
mailman
We have recently undertaken a small survey and I have to produce some charts showing people's responses. Those above me want both the actual numbers of people who responded in a particular way and the percentage value showing for each question and directorate.
I know how to create a chart with two axes - one with actual values and the other with percentages - but, because I'm displaying the results of several questions on one chart, the actual number and its associated percentage don't follow the same relationship for every question. Is this clear or am I talking gibberish?
Can anyone explain how I might create a bar-graph which performs the requirements shown above and on which I can show both actual values and percentages for each bar?
Many thanks for fighting your way through this far and double thanks in advance to anyone who can help.
Regards,
mailman