jcountry22
New Member
- Joined
- Aug 15, 2014
- Messages
- 33
How can I get a line graph created w/ multiple banks & showing a trend amongst Interest vs bank Fees?
Here is the data set with Date in Column A1.
I would like the Dates grouped together so the graph only shows months.
Date Bank Fees Interest
4/30/2020 Bank 1 - 19.76
5/1/2020 Bank 1 - -
5/18/2020 Bank 1 - -
5/29/2020 Bank 1 - 26.37
6/12/2020 Bank 1 - -
6/29/2020 Bank 1 - -
6/30/2020 Bank 1 - 12.46
7/10/2020 Bank 1 - -
7/31/2020 Bank 1 10.00 1.19
8/31/2020 Bank 1 10.00 -
9/30/2020 Bank 1 10.00 0.01
10/30/2020 Bank 1 10.00 -
11/30/2020 Bank 1 10.00 0.01
12/31/2020 Bank 1 10.00 -
4/30/2020 Bank 2 - 91.94
5/15/2020 Bank 2 - -
5/29/2020 Bank 2 - 120.12
6/12/2020 Bank 2 - -
6/26/2020 Bank 2 - -
6/30/2020 Bank 2 - 50.14
7/10/2020 Bank 2 - -
7/31/2020 Bank 2 10.00 3.43
8/31/2020 Bank 2 10.00 0.03
9/30/2020 Bank 2 10.00 0.04
10/30/2020 Bank 2 10.00 0.03
11/30/2020 Bank 2 10.00 0.02
12/31/2020 Bank 2 10.00 0.03
4/30/2020 Bank 3 - 24.63
5/15/2020 Bank 3 - -
5/29/2020 Bank 3 - 32.17
6/12/2020 Bank 3 - -
6/26/2020 Bank 3 - -
6/30/2020 Bank 3 - 12.33
7/10/2020 Bank 3 - -
7/31/2020 Bank 3 10.00 0.38
8/31/2020 Bank 3 10.00 0.01
9/30/2020 Bank 3 10.00 -
10/30/2020 Bank 3 10.00 0.01
11/30/2020 Bank 3 10.00 -
12/31/2020 Bank 3 10.00 -
4/30/2020 Bank 4 - 32.94
5/1/2020 Bank 4 - -
5/18/2020 Bank 4 - -
5/29/2020 Bank 4 - 43.64
6/12/2020 Bank 4 - -
6/26/2020 Bank 4 - -
6/30/2020 Bank 4 - 15.87
7/10/2020 Bank 4 - -
7/31/2020 Bank 4 10.00 0.56
8/31/2020 Bank 4 10.00 0.01
9/30/2020 Bank 4 10.00 0.01
10/30/2020 Bank 4 10.00 0.01
11/30/2020 Bank 4 10.00 -
12/31/2020 Bank 4 10.00 0.01
4/30/2020 Bank 5 - 113.10
5/15/2020 Bank 5 - -
5/29/2020 Bank 5 - 155.95
6/12/2020 Bank 5 - -
6/26/2020 Bank 5 - -
6/30/2020 Bank 5 - 85.99
7/10/2020 Bank 5 - -
7/24/2020 Bank 5 - -
7/31/2020 Bank 5 10.00 17.54
8/31/2020 Bank 5 10.00 0.04
9/30/2020 Bank 5 10.00 0.05
10/30/2020 Bank 5 10.00 0.04
11/30/2020 Bank 5 10.00 0.04
12/31/2020 Bank 5 10.00 0.04
4/30/2020 Bank 6 - 40.28
5/15/2020 Bank 6 - -
5/29/2020 Bank 6 - 49.88
6/12/2020 Bank 6 - -
6/26/2020 Bank 6 - -
6/30/2020 Bank 6 10.00 17.55
7/13/2020 Bank 6 (10.00) -
7/31/2020 Bank 6 10.00 0.02
8/31/2020 Bank 6 10.00 0.01
9/30/2020 Bank 6 10.00 0.01
10/30/2020 Bank 6 10.00 0.01
11/30/2020 Bank 6 10.00 0.01
12/31/2020 Bank 6 10.00 0.01
4/30/2020 Bank 7 - 38.01
5/15/2020 Bank 7 - -
5/29/2020 Bank 7 - 57.52
6/12/2020 Bank 7 - -
6/26/2020 Bank 7 - -
6/30/2020 Bank 7 - 32.15
7/10/2020 Bank 7 - -
7/24/2020 Bank 7 - -
7/31/2020 Bank 7 10.00 8.15
8/31/2020 Bank 7 10.00 0.02
9/30/2020 Bank 7 10.00 0.01
10/30/2020 Bank 7 10.00 0.01
11/30/2020 Bank 7 10.00 0.02
12/31/2020 Bank 7 10.00 0.01
4/30/2020 Bank 8 - 20.35
5/8/2020 Bank 8 - -
5/18/2020 Bank 8 - -
5/29/2020 Bank 8 - 30.86
6/12/2020 Bank 8 - -
6/29/2020 Bank 8 - -
6/30/2020 Bank 8 - 15.10
7/10/2020 Bank 8 - -
7/31/2020 Bank 8 10.00 2.04
8/31/2020 Bank 8 10.00 -
9/30/2020 Bank 8 10.00 0.01
10/30/2020 Bank 8 10.00 -
11/30/2020 Bank 8 10.00 0.01
12/31/2020 Bank 8 10.00 -
Here is the data set with Date in Column A1.
I would like the Dates grouped together so the graph only shows months.
Date Bank Fees Interest
4/30/2020 Bank 1 - 19.76
5/1/2020 Bank 1 - -
5/18/2020 Bank 1 - -
5/29/2020 Bank 1 - 26.37
6/12/2020 Bank 1 - -
6/29/2020 Bank 1 - -
6/30/2020 Bank 1 - 12.46
7/10/2020 Bank 1 - -
7/31/2020 Bank 1 10.00 1.19
8/31/2020 Bank 1 10.00 -
9/30/2020 Bank 1 10.00 0.01
10/30/2020 Bank 1 10.00 -
11/30/2020 Bank 1 10.00 0.01
12/31/2020 Bank 1 10.00 -
4/30/2020 Bank 2 - 91.94
5/15/2020 Bank 2 - -
5/29/2020 Bank 2 - 120.12
6/12/2020 Bank 2 - -
6/26/2020 Bank 2 - -
6/30/2020 Bank 2 - 50.14
7/10/2020 Bank 2 - -
7/31/2020 Bank 2 10.00 3.43
8/31/2020 Bank 2 10.00 0.03
9/30/2020 Bank 2 10.00 0.04
10/30/2020 Bank 2 10.00 0.03
11/30/2020 Bank 2 10.00 0.02
12/31/2020 Bank 2 10.00 0.03
4/30/2020 Bank 3 - 24.63
5/15/2020 Bank 3 - -
5/29/2020 Bank 3 - 32.17
6/12/2020 Bank 3 - -
6/26/2020 Bank 3 - -
6/30/2020 Bank 3 - 12.33
7/10/2020 Bank 3 - -
7/31/2020 Bank 3 10.00 0.38
8/31/2020 Bank 3 10.00 0.01
9/30/2020 Bank 3 10.00 -
10/30/2020 Bank 3 10.00 0.01
11/30/2020 Bank 3 10.00 -
12/31/2020 Bank 3 10.00 -
4/30/2020 Bank 4 - 32.94
5/1/2020 Bank 4 - -
5/18/2020 Bank 4 - -
5/29/2020 Bank 4 - 43.64
6/12/2020 Bank 4 - -
6/26/2020 Bank 4 - -
6/30/2020 Bank 4 - 15.87
7/10/2020 Bank 4 - -
7/31/2020 Bank 4 10.00 0.56
8/31/2020 Bank 4 10.00 0.01
9/30/2020 Bank 4 10.00 0.01
10/30/2020 Bank 4 10.00 0.01
11/30/2020 Bank 4 10.00 -
12/31/2020 Bank 4 10.00 0.01
4/30/2020 Bank 5 - 113.10
5/15/2020 Bank 5 - -
5/29/2020 Bank 5 - 155.95
6/12/2020 Bank 5 - -
6/26/2020 Bank 5 - -
6/30/2020 Bank 5 - 85.99
7/10/2020 Bank 5 - -
7/24/2020 Bank 5 - -
7/31/2020 Bank 5 10.00 17.54
8/31/2020 Bank 5 10.00 0.04
9/30/2020 Bank 5 10.00 0.05
10/30/2020 Bank 5 10.00 0.04
11/30/2020 Bank 5 10.00 0.04
12/31/2020 Bank 5 10.00 0.04
4/30/2020 Bank 6 - 40.28
5/15/2020 Bank 6 - -
5/29/2020 Bank 6 - 49.88
6/12/2020 Bank 6 - -
6/26/2020 Bank 6 - -
6/30/2020 Bank 6 10.00 17.55
7/13/2020 Bank 6 (10.00) -
7/31/2020 Bank 6 10.00 0.02
8/31/2020 Bank 6 10.00 0.01
9/30/2020 Bank 6 10.00 0.01
10/30/2020 Bank 6 10.00 0.01
11/30/2020 Bank 6 10.00 0.01
12/31/2020 Bank 6 10.00 0.01
4/30/2020 Bank 7 - 38.01
5/15/2020 Bank 7 - -
5/29/2020 Bank 7 - 57.52
6/12/2020 Bank 7 - -
6/26/2020 Bank 7 - -
6/30/2020 Bank 7 - 32.15
7/10/2020 Bank 7 - -
7/24/2020 Bank 7 - -
7/31/2020 Bank 7 10.00 8.15
8/31/2020 Bank 7 10.00 0.02
9/30/2020 Bank 7 10.00 0.01
10/30/2020 Bank 7 10.00 0.01
11/30/2020 Bank 7 10.00 0.02
12/31/2020 Bank 7 10.00 0.01
4/30/2020 Bank 8 - 20.35
5/8/2020 Bank 8 - -
5/18/2020 Bank 8 - -
5/29/2020 Bank 8 - 30.86
6/12/2020 Bank 8 - -
6/29/2020 Bank 8 - -
6/30/2020 Bank 8 - 15.10
7/10/2020 Bank 8 - -
7/31/2020 Bank 8 10.00 2.04
8/31/2020 Bank 8 10.00 -
9/30/2020 Bank 8 10.00 0.01
10/30/2020 Bank 8 10.00 -
11/30/2020 Bank 8 10.00 0.01
12/31/2020 Bank 8 10.00 -