Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
direction of delta using arrows
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
direction of delta using arrows
You might want to take a look at Jon Peltier's article on waterfall charts.
http://peltiertech.com/Excel/Charts/...ngColumns.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!* "casey" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
direction of delta using arrows
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 "Luke M" wrote: You might want to take a look at Jon Peltier's article on waterfall charts. http://peltiertech.com/Excel/Charts/...ngColumns.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!* "casey" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
direction of delta using arrows
Maybe you could find some arrow symbols in a common font and use those, for
example: =IF(B10,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. "casey" wrote in message ... 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 "Luke M" wrote: You might want to take a look at Jon Peltier's article on waterfall charts. http://peltiertech.com/Excel/Charts/...ngColumns.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!* "casey" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delta E(cmc) formula | Excel Worksheet Functions | |||
Delta Variances by Period | Excel Discussion (Misc queries) | |||
Problem inserting delta symbol into Excel | Charts and Charting in Excel | |||
convert numbers to positive and keep delta value | Excel Discussion (Misc queries) | |||
greek symbol delta | Excel Discussion (Misc queries) |