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 |
+-------------------------------------------------------------------+
--
chinois
------------------------------------------------------------------------
chinois's Profile:
http://www.excelforum.com/member.php...o&userid=29985
View this thread:
http://www.excelforum.com/showthread...hreadid=496794