ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   High Low Lines or Delta between two data sets (https://www.excelbanter.com/charts-charting-excel/195498-high-low-lines-delta-between-two-data-sets.html)

Jeff

High Low Lines or Delta between two data sets
 
I have two data sets I am tracking against each other and I would like to be
able to display the delta between the two lines.

the high low lines would be great if you could add a delta number to them
but I don't think that is possible. is there some other functionality that
will give me this?

Example if one value is 5 and the other is 8 I would like a line between
them with a 3 on it.

Any Ideas

Thanks
--
Jeff

Andy Pope

High Low Lines or Delta between two data sets
 
Hi,

You can create this chart appearance.
http://www.andypope.info/charts/Hilolabel.htm

Cheers
Andy

Jeff wrote:
I have two data sets I am tracking against each other and I would like to be
able to display the delta between the two lines.

the high low lines would be great if you could add a delta number to them
but I don't think that is possible. is there some other functionality that
will give me this?

Example if one value is 5 and the other is 8 I would like a line between
them with a 3 on it.

Any Ideas

Thanks


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 02:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com