Hi,

In order to get the differences to appear in the built-in data table you
will need to add a third series to the chart which is the difference
between A and B. The problem is that all series will appear in the data
table.
You might find it easier to place the difference values in worksheet
cells and alight the chart accordingly.

Cheers
Andy

chinois wrote:
I have two sets of numbers that I've graphed in a basic line graph:
Series A & Series B. I want to edit the line graph and put a data table
at the bottom that automatically caluclates and displays the value of A
minus B.

The attached file shows what I want the graph to look like, but I've
manually inserted text boxes below the X Axis to display the
differences; I'd like to have them automatically calculated as I enter
new values for Series A & B.

Does anyone have advice on this?

Thanks,
Mike


+-------------------------------------------------------------------+
|Filename: LineGraphExample.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4161 |
+-------------------------------------------------------------------+


--

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