Greetings All,
I want to display the results of a survey on a 100% stacked bar graph (horizontal) in Excel 2007 (please see below for a link to the image).
The Series Labels are "Miserable", "Not Satisfied", "Satisfied", and "Ecstatic".
The Series Values are the percentage of responses for each Series Label.
There are three Categories: "Survey1", "Survey2", and "Survey3".
I want the negative values on the chart and the axis displayed as positive values, but I do not want the layout of the chart changed. Specifically, I want the "0" position of the X-axis to remain in the center, I want the percentage of responses for "Miserable" and "Not Satisfied' to remain on the left side of the "0" line, and I want the negative numbers to display as positive numbers.
Can anyone help me with this?
Thanks in advance.
http://www.flickr.com/photos/26489703@N07/4551402547/
I want to display the results of a survey on a 100% stacked bar graph (horizontal) in Excel 2007 (please see below for a link to the image).
The Series Labels are "Miserable", "Not Satisfied", "Satisfied", and "Ecstatic".
The Series Values are the percentage of responses for each Series Label.
There are three Categories: "Survey1", "Survey2", and "Survey3".
I want the negative values on the chart and the axis displayed as positive values, but I do not want the layout of the chart changed. Specifically, I want the "0" position of the X-axis to remain in the center, I want the percentage of responses for "Miserable" and "Not Satisfied' to remain on the left side of the "0" line, and I want the negative numbers to display as positive numbers.
Can anyone help me with this?
Thanks in advance.
http://www.flickr.com/photos/26489703@N07/4551402547/