How to create graph with 2 Y axis (percentage and confidence interval) in Excel?

Hi there

I am Sue and am currently working on my master thesis in Switzerland. I am stuck with an Excel diagram that I don't know how to create. Can anyone help me?

In my diagram, I would like to show 8 categories on the X axis (recruiting, staff development etc.). On the Y axis, I would like to show the percentage of answers for each category (e.g. 18%) as well as the confidence interval with the lower and upper range. What kind of a chart do I have to use in Excel to bring all this information into 1 diagram?

Attached, you see a sample picture I found on the web of how it should look like as well as a hand-written graph I have done.

Thanks a million for any advice, I am absolutely stuck with this.
Sue
sample graph.gif
handdrawn graph.jpg

Hi Oeldere

Thanks a lot for your reply. You are my magic angel for today, as I just figured it out by looking up the source - and I noticed that they explain how to do it there. Honestly quite embarrassing that I didn't check this first... Here's the link just in case you are interested. http://www.biostathandbook.com/graph.html

Kind regards
Sue

See for such a solution. Used this data source created by oeldere. I've added a calculated field that shows Variance in%

I'm sorry but my above answer does not apply to your post