2 Variable Graph - want average line???
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 |
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/ _______ qthisup wrote: 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 |
All times are GMT +1. The time now is 10:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com