Hello everyone (first post),
I am putting together a graph that will track tasks per person and show how many are open less than 15 days, between 15 and 30 days and over 30 days and how many have been closed by that person in less than 15 days, between 15 and 30 days and over 30 days.

Currently, there is a column titled "Date Issued", a column titled "PERSON" that the name of the responsable person will be entered in for each task, a column titled "Days open" that used the formula below to calculate the days the task was open until it was closed, and a column titled "closed date" where the date the task was completed is entered.

=IF([Date Issued]="","",IF([closed date]="",[Today()]-[Date Issued],[closed date]-[date issued]))

I have no idea how to set up a graph that will pull the names from "Person" column and stack the 3 different date conditions I want to see. If anyone has any suggestions, I would greatly appreciate it.

Thanks