want to be able to select date range for my chart

[dougers1]

H I am looking for some help. I have a spreadsheet that I use at work the someone made but has now left, at the moment in the Chart tab I can select a date and it gives me scores of everyone and the average score.

what I want to be able to do is for it to allow me to select a range of dates example 1st to 7th

how do I do this.

please help

[avk]

While going through sheet "Chart". No date found.
In column "B" found formula

Please Login or Register  to view this content.

Can you share / attach your file "Driving performance1 (1).xlsx"

[dougers1]

yeah no problem here it is.

[avk]

Refer attach file.
In "Chart" sheet i have add Date column. Which is select by "Data Validation"
and select data column "A:D"

[dougers1]

I still cant select a date range, for example 1st to 7th

[avk]

From where select a date range. can you input manually in sheet. What you actual required.

[dougers1]

In Chart tab column B named Date, at the moment I can only select on day at a time, I would like to be able to select a weeks, months

[JeteMc]

Here is an adaptation to AVK's solution that adds a column C as an end date. The formula that yields the average score for each individual over the range chosen is:

Please Login or Register  to view this content.

Let us know if you have any questions.

[dougers1]

thanks that's perfect

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.