Prev: line chart plots false value and the real value on same date
Next: Set multiple fills in single column based on value
From: Keith on 10 Feb 2010 11:50
How do I describe this in words?
I need to create an Excel chart with these characteristics.
There are horizontal bars, centered vertically at zero. One value is
presented to the left, another to the right. They represent paired choices
from a survey. For example, given the option as to whether people might
pay-down debt, vs. purchase a car, about 75% will say they want to pay down
debt, while 25% will say they will purchase a car. So by setting the value
of 75 to a -75, and using horizontal stacked bar chart, I have a bar to the
left of zero showing 75% and a bar to the right showing 25%. It looks great
and shows the comparison needed. The problem is getting the labels correct.
I need the appropriate label on each bar, left of zero and right of zero, and
up and down, for each pair of survey responses.

There should be two options: (1) I could insert a text box on each bar, or,
(2) I should be able to put the labels in a column and have them
automatically. Option 1 is easy, but time-consumng, and option 2 would be
more flexible when I do updates to the chart. I can't figure out how to do
option 2. Any suggestions?

keith

From: trip_to_tokyo on 10 Feb 2010 12:35
Hi Keith, I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 59 towards the top of my home page.

It is not identical to your requirements but similar and I hope that it will
be helpful to you in some way.

It's pulled direct from MS documentation (and I have cross referenced it to
that).

Pleas hit Yes if my comments have helped.

Thanks.



"Keith" wrote:

> How do I describe this in words?
> I need to create an Excel chart with these characteristics.
> There are horizontal bars, centered vertically at zero. One value is
> presented to the left, another to the right. They represent paired choices
> from a survey. For example, given the option as to whether people might
> pay-down debt, vs. purchase a car, about 75% will say they want to pay down
> debt, while 25% will say they will purchase a car. So by setting the value
> of 75 to a -75, and using horizontal stacked bar chart, I have a bar to the
> left of zero showing 75% and a bar to the right showing 25%. It looks great
> and shows the comparison needed. The problem is getting the labels correct.
> I need the appropriate label on each bar, left of zero and right of zero, and
> up and down, for each pair of survey responses.
>
> There should be two options: (1) I could insert a text box on each bar, or,
> (2) I should be able to put the labels in a column and have them
> automatically. Option 1 is easy, but time-consumng, and option 2 would be
> more flexible when I do updates to the chart. I can't figure out how to do
> option 2. Any suggestions?
>
> keith
>
 | 
Pages: 1
Prev: line chart plots false value and the real value on same date
Next: Set multiple fills in single column based on value