Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Label an average line in a dynamic chart | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Plotting moving average line on a chart | Charts and Charting in Excel | |||
Line and Column Graph | Charts and Charting in Excel | |||
Can you have a vertical line graph in Excel 2003 | Charts and Charting in Excel |