LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 80
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delta E(cmc) formula Michelle7890 Excel Worksheet Functions 11 April 4th 23 11:22 AM
Delta Variances by Period MrRJ Excel Discussion (Misc queries) 8 February 10th 09 08:51 PM
Problem inserting delta symbol into Excel [email protected] Charts and Charting in Excel 5 September 13th 07 05:47 PM
convert numbers to positive and keep delta value nolenkw Excel Discussion (Misc queries) 3 August 11th 06 05:15 PM
greek symbol delta afdmello Excel Discussion (Misc queries) 1 October 23rd 05 07:31 PM


All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"