Automated time buckets from daily table data

[MistyWind]

Hello. My question may seem very simple but I'd like to automate this process as much as possible.
I'd like to created daily, weekly, monthly and quarterly charts from one table that has daily data. The table is simple; Column A is date, Column B is simple whole numbers. Is there any way I can create these charts up front so when I populate the daily data the charts update? Or is there another recommended/efficient way of accomplishing what I'm trying to do? Thanks.

 

[etaf]

you could use a PIVOT CHART and group the data by Quarter/month/week/day

not sure if this will work with XL2BB

Grouping Pivot Table Dates by Months and Weeks – Excel Pivot Tables

www.pivot-table.com

Book1
	A	B	C	D	E	F	G	H	I	J
1
2
3	Row Labels	Sum of Amount
4	<01/01/2020
5	Qtr1	28.28571429
6	Qtr2	49.71428571
7	Qtr3	40.8
8	Grand Total	118.8
9
10
11
12
13
14
15
16
Sheet4