Trendline on difference between two columns

  • Thread starter Thread starter Old Red One
  • Start date Start date
O

Old Red One

How do I create a trendline illuminating the spread between two columns of
numbers, such as bond yields; e.g. a trend showing differencwe between a ten
year bond and ten year Treasury Inflation Protected bonds over time?
 
Red,

Make a third column in your sheet, include it in your chart, and change it
to a line chart. To change to line, when it comes up as a column, select
that series - right-click - Chart type - Line. The third column should have
a formula that calculates the difference.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top