How do I add a horizontal data line to a column chart?

[soconfused]

I have two columns of data which I have charted, now I would like to put the
differences between the two.

For instance, if I have 926-843= 83, I want to be able to put that number on
my chart to show the difference.

Thanks

 

[Jon Peltier]

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

- Jon

 

[soconfused]

Jon, I'm having a bit of trouble with this.

On my chart at the present time, I have dates on the left axis and text on
the bottom axis. The info in the chart are projected dates and actual dates.
I've been asked to put the difference for each category I don't necessarily
have to plot it, just have the numbers there. Can you help me?

 

[Jon Peltier]

When you said data line, I was not thinking of a set of labels in a line,
but rather of a line showing a target.

Compute the difference in the worksheet, then use one of these utilities to
add these values to one of the series as data labels:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

Or add an invisible line chart series (no line, no markers) to the chart,
using a dummy date to position the points where you want them, and hang the
labels on this series.

- Jon

 

[soconfused]

Thanks so much, that worked great. At some point I will be able to phrase my
questions properly.

Thanks.