direction of delta using arrows

[casey]

Consider the following data.

Q1) Is there a way to show the delta in a column (maybe floating column)
chart with a block arrow showing the direction of change instead of a regular
column? (2nd data set)

Q2) AND, show the %delta as well (3rd data set)? (I've tried staggering the
data on a secondary axis [as I have in other charts] but it ends up 'under'
its respective column.)

RED WHITE BLUE
Jan-09 20 35 8
Feb-09 25 40 6
Mar-09 32 45 4
Apr-09 28 40 6
May-09 20 40 2

DELTA RED WHITE BLUE
Feb-09 5 5 -2
Mar-09 7 5 -2
Apr-09 -4 -5 2
May-09 -8 0 -4

%DELTA RED WHITE BLUE
Feb-09 25.0% 14.3% -25.0%
Mar-09 28.0% 12.5% -33.3%
Apr-09 -12.5% -11.1% 50.0%
May-09 -28.6% 0.0% -66.7%

TIA for any help.
casey

 

[Luke M]

You might want to take a look at Jon Peltier's article on waterfall charts.

http://peltiertech.com/Excel/Charts/FloatingColumns.html

Note sure how to implement the percentage feature, but I'm sure its possible
using either a stacked chart or a secondary axis. Make sure you look at some
of Jon's other chart tips.

 

[casey]

Luke M,

I looked at the waterfall chart and will probably use it. It's the arrows I
was hoping to attain, but in the interim until I find something better I will
use the waterfall.

Thanks for your help.

casey

You might want to take a look at Jon Peltier's article on waterfall charts.

http://peltiertech.com/Excel/Charts/FloatingColumns.html

Note sure how to implement the percentage feature, but I'm sure its possible
using either a stacked chart or a secondary axis. Make sure you look at some
of Jon's other chart tips.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Consider the following data.

Q1) Is there a way to show the delta in a column (maybe floating column)
chart with a block arrow showing the direction of change instead of a regular
column? (2nd data set)

Q2) AND, show the %delta as well (3rd data set)? (I've tried staggering the
data on a secondary axis [as I have in other charts] but it ends up 'under'
its respective column.)

RED WHITE BLUE
Jan-09 20 35 8
Feb-09 25 40 6
Mar-09 32 45 4
Apr-09 28 40 6
May-09 20 40 2

DELTA RED WHITE BLUE
Feb-09 5 5 -2
Mar-09 7 5 -2
Apr-09 -4 -5 2
May-09 -8 0 -4

%DELTA RED WHITE BLUE
Feb-09 25.0% 14.3% -25.0%
Mar-09 28.0% 12.5% -33.3%
Apr-09 -12.5% -11.1% 50.0%
May-09 -28.6% 0.0% -66.7%

TIA for any help.
casey

 

[Stephen Bye]

Maybe you could find some arrow symbols in a common font and use those, for
example:
=IF(B1>0,CHAR(233),CHAR(234))
with the cell formatted with the "WingDings" font.
This will show up or down arrows depending on the value in B1.

Luke M,

I looked at the waterfall chart and will probably use it. It's the arrows
I
was hoping to attain, but in the interim until I find something better I
will
use the waterfall.

Thanks for your help.

casey

You might want to take a look at Jon Peltier's article on waterfall
charts.

http://peltiertech.com/Excel/Charts/FloatingColumns.html

Note sure how to implement the percentage feature, but I'm sure its
possible
using either a stacked chart or a secondary axis. Make sure you look at
some
of Jon's other chart tips.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Consider the following data.

Q1) Is there a way to show the delta in a column (maybe floating
column)
chart with a block arrow showing the direction of change instead of a
regular
column? (2nd data set)

Q2) AND, show the %delta as well (3rd data set)? (I've tried
staggering the
data on a secondary axis [as I have in other charts] but it ends up
'under'
its respective column.)

RED WHITE BLUE
Jan-09 20 35 8
Feb-09 25 40 6
Mar-09 32 45 4
Apr-09 28 40 6
May-09 20 40 2

DELTA RED WHITE BLUE
Feb-09 5 5 -2
Mar-09 7 5 -2
Apr-09 -4 -5 2
May-09 -8 0 -4

%DELTA RED WHITE BLUE
Feb-09 25.0% 14.3% -25.0%
Mar-09 28.0% 12.5% -33.3%
Apr-09 -12.5% -11.1% 50.0%
May-09 -28.6% 0.0% -66.7%

TIA for any help.
casey