How to make a graph of bank account data in excel with a table of balance changes?

To get the effect you want you will need to use a normal bar graph and change some of the options. Here is a tutorial you can follow. I've edited to make it easier to understand for less skilled excel users. Here is the final result after following the tutorial.

enter image description here


Chart

  1. Select both data without the headers
  2. Go to the tab "Insert"
  3. Click on the dropdown list "Insert collumn or bar chart"
  4. Click on "Clustered Collumn"

Clustered Collumn

  1. Then click on a bar and make sure its selected (it will have blue dots on the edges.
  2. Click on the "Plus sign" hover over axes click on the arrow and then more options.

enter image description here

  1. Now select the bars again and an option menu should appear on the right
  2. Make the "Gap Width" 0%

enter image description here


Data points format

To make the dates align.

  1. Click on one of the dates in the graph to select them
  2. Open the menu. See step 5 - 6 from Chart.
  3. Click on one of the dates to select them again.
  4. Now in the option menu select the option "On Tick marks"
  5. At the dropdown "Tick Marks" change the Major type to "Inside"

enter image description here