View Single Post
  #3   Report Post  
Basil
 
Posts: n/a
Default

I was looking for a way that didn't rely on seperate text boxes.

"bj" wrote:

one way to do it, (If I understand what you want) on the spread sheet
calculate the difference in say D1:D4
on the chart start a text box and in the formula bar enter = and point to
the cell with the difference.
format the text box for the alignment and fill colors you want and place it
on the
down bar for each data point pair.


"Basil" wrote:

Hiya,

I have a line chart with two lines. I have included down bars from the upper
line. I would like the difference of value between the two lines (i.e. the
height of the down bars) to be shown within the down bars.

Is this possible?

Thanks,

Basil