Hello, I am trying to chart the following data based on the current calendar week.
1) I would like to enter my data into the box labeled "Step 1" on a daily basis. I will be entering this data every week, 6 days a week. I would like all 6 days totaled up and auto populated into the current calendar week in the second box outlined in yellow.
2) I am wanting to chart this information into a cluster bar graph.
How can I make a total sum of each day populate based off of the current calendar week?
1) I would like to enter my data into the box labeled "Step 1" on a daily basis. I will be entering this data every week, 6 days a week. I would like all 6 days totaled up and auto populated into the current calendar week in the second box outlined in yellow.
2) I am wanting to chart this information into a cluster bar graph.
How can I make a total sum of each day populate based off of the current calendar week?