2 Variable Graph - want average line???

[Guest]

Hi all,

I have a 2 variable graph, prices on left axis, interest rates on the right
axis with years on the bottom.

I would like to add 2 lines without having to draw them:
1) Average interst rate line.
2) Current interest rate line.

How do i do this?? I've tried adding another series with the average
entered into every year but then my actul interest rate line dissappears to
sit at the bottom (i think it thinks it is a price) AHHHHHH

Thanks

 

[Jon Peltier]

Don't use one of Excel's built-in custom chart types. Make a new chart
with all your data: prices, rates, average, and current. Double click on
one of the rate series, and on the Axis tab select Secondary. Repeat for
the other rate series (select a series and use the handy F4 shortcut to
repeat the previous action).

As an alternative, try one of these approaches:

http://peltiertech.com/Excel/Charts/AddLine.html

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