How can I make a "CD (certificate of deposit) Ladder" bar chart?

yeto

New Member
Joined
Mar 1, 2012
Messages
32
Office Version
  1. 2010
Platform
  1. Windows
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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Would you want something like this? It's a simple stacked column chart.
1687692874762.png
 
Upvote 0
Solution
Yes, that looks good. I will give it a try.

Thank you for taking time to reply.

Thank you,
yeto
 
Upvote 0

Forum statistics

Threads
1,215,085
Messages
6,123,030
Members
449,092
Latest member
ikke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top