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

[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

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

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


"Andy Pope" <[email protected]> wrote in message
news:[email protected]...
> 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