Graph Negative Values as Positive Values

Joined
Apr 25, 2010
Messages
1
Reaction score
0
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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top