Fill up the cylinder

  • Thread starter Thread starter Doria/Warris
  • Start date Start date
D

Doria/Warris

Hi,

I made a chart stacked cylinder type, there are 3 values in it, 100%, 40%
and 20%.

100% is a fix target.
Is there a way to see the growth or decrease of the other two values with
filling effect?
What I mean is that the 3 values have three colours, I'd like to see the 40%
and 20% values increase or decrease vs the 100%.

As it is now, the 2 colours increase but the 100% fix target moves
proportionally above them.

Hope you can help

Thank you
Alex
 
Alex -

If the two smaller percentages represent fractions of the 100%, you
should not use 100% as the value of the third series. You should use a
formula which tells you the remainder, that is 100% minus the first two.
For example, if the stack takes values from B2, C2, and D2, the formula
in D2 should be

=1-B2-C2

As B2 and C2 change, the amount of the 100% that remains will also change.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top