Need stacked chart help

[wjviveen]

Hi All,

I have a problem with a stacked chart in excel 2000, i have used th
search function but could not find a solution.

The problem is as follows:

I want to create a chart with one stacked bar (consisting of
variables). And i also
want another stacked bar (consisting of 2 variables). Only the proble
is that
there is a big difference in the numbers so one hardly shows up.

Now i want both bars on different scales.

Can somebody help me ?

Thanks in advance

 

[Barb Reinhardt]

Have you tried plotting it on a LOG scale?

 

[Barb Reinhardt]

Ignore my last response. I've done stacked charts in Log scale and the
upper part of the stack appears to be smaller than the bottom part of the
stack. It's very mislieading. It would work for one data point, not
stacks.

 

[Guenther]

Have you had any response to this? I am in need of the same chart, but
haven't been able to find any information on this type of chart. I will keep
watching this thread in hopes of a solution
Guenther

 

[wjviveen]

I am still working on this problem..
It looks so simple, but i cant find any solution...

I needed it for an presentation that i made for my boss last week.
The presentation has already been given. It is now a battle between hi
and
me to make this graph work.. ;

 

[Andy Pope]

Hi,

Here a very quick overview,
http://www.andypope.info/ngs/ng29.htm

Cheers
Andy