Create a bar graph with axis in the middle (negative values on left of axis)
Suppose you have a question on customer satisfaction, and you have negative ratings and positive ratings categories. You want to make a bar chart where everything is aligned in the middle so that the positive ratings emanate to the right of the vertical axis and the negative ratings emanate to the left of the vertical axis.
Here is an example:
To create this chart, there are 2 steps:
1. Recode your ratings categories so the negative ratings have negative values, and the positive ratings have position values. Use Data Manipulation > Data Values > Values to do this, as in the following example:
2. Change the chart type. Click HOME > Charts > Chart > Stacked plots > Stacked bar plot with negatives, as in the following screenshot: