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.
Chart
- Select both data without the headers
- Go to the tab "Insert"
- Click on the dropdown list "Insert collumn or bar chart"
- Click on "Clustered Collumn"
- Then click on a bar and make sure its selected (it will have blue dots on the edges.
- Click on the "Plus sign" hover over axes click on the arrow and then more options.
- Now select the bars again and an option menu should appear on the right
- Make the "Gap Width" 0%
Data points format
To make the dates align.
- Click on one of the dates in the graph to select them
- Open the menu. See step 5 - 6 from Chart.
- Click on one of the dates to select them again.
- Now in the option menu select the option "On Tick marks"
- At the dropdown "Tick Marks" change the Major type to "Inside"