Hi,
I have searched on the internet and I can't find how to make a CD ladder bar chart. I would like for the bar chart to be vertical.
My input would look like this:
1) Qty or value of CD > 5M; 10M etc.
2) Maturity date > 7/3/2023; 8/10/2023 etc.
3) Interest rate CD is earning: 5.00%
I would like for the end result to have vertical bars that show the value of the CDs and as the chart moves from left to right the maturity date moves farther out. It would also be nice if I could show the interest rate that each CD is earning. I don't need the spreadsheet chart to calculate the interest rate. I will already know the interest rate and can input that myself.
Thank you in advance for any help,
yeto
I have searched on the internet and I can't find how to make a CD ladder bar chart. I would like for the bar chart to be vertical.
My input would look like this:
1) Qty or value of CD > 5M; 10M etc.
2) Maturity date > 7/3/2023; 8/10/2023 etc.
3) Interest rate CD is earning: 5.00%
I would like for the end result to have vertical bars that show the value of the CDs and as the chart moves from left to right the maturity date moves farther out. It would also be nice if I could show the interest rate that each CD is earning. I don't need the spreadsheet chart to calculate the interest rate. I will already know the interest rate and can input that myself.
Thank you in advance for any help,
yeto