Chart help?

[samilynn]

I have a file like the attached sample with daily transactions. Is it possible to create a bar chart that shows the account balance at the end of the day? I'm having a really hard time figuring it out..thanks!

Samantha

 

[awoohaw]

Try this: (You may need to enter with CNTL-SHFT-ENTR keystroke)
edited (for 2016, i had 365 formulas in it)

This works when the formula for EOD Bal starts in row 4. You would need to adjust accordingly.

PriorCampoutAnalysis.xlsx
	A	B	C	D	E
1
2
3	Date	Balance		Date	EOD Bal
4	2024-05-15	1611		2024-05-15	866
5	2024-05-15	1654		2024-05-16	1553
6	2024-05-15	866		2024-05-17	1447
7	2024-05-15	636
8	2024-05-15	836
9	2024-05-15	1086
10	2024-05-15	1484
11	2024-05-15	765
12	2024-05-15	866
13	2024-05-16	1088
14	2024-05-16	1207
15	2024-05-16	1542
16	2024-05-16	1053
17	2024-05-16	1381
18	2024-05-16	572
19	2024-05-16	649
20	2024-05-16	632
21	2024-05-16	1464
22	2024-05-16	840
23	2024-05-16	1292
24	2024-05-16	1553
25	2024-05-17	1272
26	2024-05-17	855
27	2024-05-17	1099
28	2024-05-17	1184
29	2024-05-17	1100
30	2024-05-17	1447
31
32
33
Sheet3

Cell Formulas
Range	Formula
E4:E6	E4	=INDEX($B$4:$B$30,MAX(($A$4:$A$30=D4)*(ROW($A$4:$A$30)-3)))

 

[samilynn]

Try this: (You may need to enter with CNTL-SHFT-ENTR keystroke)
edited (for 2016, i had 365 formulas in it)

This works when the formula for EOD Bal starts in row 4. You would need to adjust accordingly.

PriorCampoutAnalysis.xlsx
	A	B	C	D	E
1
2
3	Date	Balance		Date	EOD Bal
4	2024-05-15	1611		2024-05-15	866
5	2024-05-15	1654		2024-05-16	1553
6	2024-05-15	866		2024-05-17	1447
7	2024-05-15	636
8	2024-05-15	836
9	2024-05-15	1086
10	2024-05-15	1484
11	2024-05-15	765
12	2024-05-15	866
13	2024-05-16	1088
14	2024-05-16	1207
15	2024-05-16	1542
16	2024-05-16	1053
17	2024-05-16	1381
18	2024-05-16	572
19	2024-05-16	649
20	2024-05-16	632
21	2024-05-16	1464
22	2024-05-16	840
23	2024-05-16	1292
24	2024-05-16	1553
25	2024-05-17	1272
26	2024-05-17	855
27	2024-05-17	1099
28	2024-05-17	1184
29	2024-05-17	1100
30	2024-05-17	1447
31
32
33
Sheet3

Cell Formulas
Range	Formula
E4:E6	E4	=INDEX($B$4:$B$30,MAX(($A$4:$A$30=D4)*(ROW($A$4:$A$30)-3)))

View attachment 111274

Thank you so much!!!!

 

[awoohaw]

My pleasure, happy to help.

Best Wishes!