Prev: Set multiple fills in single column based on value
Next: I copied a file and now charts will not display.
From: Keith on 10 Feb 2010 13:15
Thank you. I'll check it out.
Keith

"trip_to_tokyo" wrote:

> 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: Set multiple fills in single column based on value
Next: I copied a file and now charts will not display.