Creating a graph with sub totals

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here is how I did it.

See this wiki on how to use the Select Data option to edit chart series manually: http://www.utteraccess.com/wiki/Dynamic_Charting,

First I set up some helper cells:
Cell D8 is a fixed 0%.
Cell E8 =C6+D6 - this is the Agree Rate.
Cell D9 =E8 - this is the starting point of the Disagree Rate
Cell E9 is a fixed 100%

Cells F8 and F9 are titles.

The values in rows 9 and 11 are to provide space between the stacked bar and the line chart.

I added a series for the agree rate. Then I changed the series type to scatter plot with straight lines (no markers). the X-Axis is D8:E8 (the Agree range) and the Y-Axis is D9:E9 (arbitrarily 5 for spacing) - this winds up on the secondary axis by default.

I added another series for the disagree rate and set it up similarly.

Then I changed the series colors to match and widened the line width to 5 points to make it easier to see.

The helper cells may be in an inconvenient place for you. If you CUT and paste them to a more convenient location, the chart will know where to find them.

P.S. This is my go-to resource for charting questions: http://www.peltiertech.com/Excel/Charts/. I managed to figure this one out on my own, but I bet I've seen something similar in the reference beforehand.

I see you've adapted the logic to add a neutral category.

I am afraid that there is no option other than to duplicate the cell structure. You don't have to have the cells under the raw data; they can be moved to the side and hidden. Cut and paste the existing cells to preserve the existing chart.

To do another population copy the existing chart and paste it into the new location. Then on the new chart, select the data and edit the ranges for the various series. "Point" the series to the new sets of cells.

One thing you can do is right click on the secondary vertical axis and delete the display. It will make the chart look prettier.