Move the legend to the top of the chart and remove the far-left instance of the “Neutral” reference by clicking on the reference two times (not a double click but 2 single clicks; pause between each click) and pressing the Delete key on the keyboard.
We still have a problem with the legend. The reference for “Disagree” is displayed first in the list but “Strongly Disagree” is displayed first in the chart.
We achieve the corrected legend order by way of a sneaky trick.
Shift the contents of cells F13:H18 to the right by one column.
Enter the label “Disagree” into cell F13.
This empty column will not supply any values to the chart but provide a mechanism to correct the order of our legend.
Add the new series to the chart by highlighting the new data (cells F13:F18) and pressing Copy. Click in a corner of the chart and press Paste. The newly added column in the data preparation table will now appear in the chart. Although you won’t see any new segments in the stacked bars, you will see a new entry for “Disagree” in the legend.
The next step is to rearrange the order of the legend. Right-click on the chart and select Select Data.
In the Select Data Source dialog box, scroll to the bottom of the Legend Entries list (left side) and click the newly added “Disagree” entry.
Using the “up/down” adjustment buttons, move the “Disagree” option up the list until it rests between “Strongly Disagree” and “Neutral” and click OK.
To synchronize the colors of the “Disagree” bar segments and the legend reference, click the legend to select it then click a second time on the middle “Disagree” reference to focus your selection to that single item.
Set the Fill Color to the same light orange you selected when customizing the chart segments.
To remove the original “Disagree” reference in the legend (left-most version), click the legend to select it then click a second time on the left-most “Disagree” reference to focus your selection to that single item.
Press the Delete key on the keyboard to remove the redundant reference.
We now have our finished Diverging Stacked Bar Chart.