Line Graph: Differences between series
 

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

Line Graph: Differences between series
 

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

Line Graph: Differences between series
 

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/
_______


"Andy Pope" wrote in message
...
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