how to make a chart that separates total data by month/year
I’ve attached a picture of the hours that are calculated in my spreadsheet (clinical, direct care, individual supervision, group supervision, direct observation and training hours.) I need to total each of the columns by month/year in a separate chart. I don’t have any data entered in the spreadsheet yet and will need the totals automatically added to the other chart as they’re entered. Can someone help me with how this chart might look and what formulas I would use? The clinical hours will be totaled for about 2 years. Thanks in advance!
I’ve attached a picture of the hours that are calculated in my spreadsheet (clinical, direct care, individual supervision, group supervision, direct observation and training hours.) I need to total each of the columns by month/year in a separate chart. I don’t have any data entered in the spreadsheet yet and will need the totals automatically added to the other chart as they’re entered. Can someone help me with how this chart might look and what formulas I would use? The clinical hours will be totaled for about 2 years. Thanks in advance! Read More