Line Graph: Differences between series

[chinois]

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 tabl
at the bottom that automatically caluclates and displays the value of
minus B.

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

Does anyone have advice on this?

Thanks,
Mik

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

 

[Andy Pope]

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

 

[Jon Peltier]

Alternatively, you can keep using the textboxes, but link them to cells that
have the calculated values. To do this, select a textbox, type '=' in the
formula bar, and with the cursor still in the formula bar, select the cell
with the value you want to display.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______