connecting two chart lines

[bob]

Hi.
I have two data series which represent declining balances
for a home loan. At some point I transfer the balance in
series1 to series2. So Series1 stops at its last balance.
Series2 will jump vertically, because it has the balance
from series1 added to it. Then series2 once again
continues with a declining balance. My question is how do
I create a vertical line to join series1 with
series2.Thanks

 

[Jon Peltier]

Bob -

You could add a third series with only two points, the endpoints of the
two series. If it is really a vertical line, you could also use an error
bar of the appropriate length on one of the endpoints. You need to enter
all zeros in a range, except for the cell corresponding to the error bar
having a formula providing the difference between the formulas. Add
error bars to one series, clicking in the Custom + or - box (whichever
shows it the correct way), selecting the range described above for the
error bar values.

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

 

[bob]

Thankyou very much.
I 'll play with the error bars.