Chart to show date differences with blanks in data

The Attached worksheet should work for you.

The first thing I did was to convert your basic data into an Excel Table. Excel Tables have many advantages. Some of them are:

• They "know" how big they are so formulas, pivot tables and charts built on them react automatically when the table data grows or shrinks
• As new data are added, they automatically become part of the table
• Tables automatically "copy down" formulas, formats and validations.
• They "remember" formulas. If you empty out this table and put in new data, the formulas return
• Formulas are expressed in terms of header names rather than cell references which make them easier to understand and debug. This even works in VB!

I suggest you do a web search on Excel Table Tutorial. They are worth learning.

I modified and added formulas

Column F is =IF(ISBLANK([@[Date Released]]),NA(),[@[Date Released]]-[@[Date Received]]) -- this gives the difference between received and closed date or blank if it's still open.
Column G is =IF(ISBLANK([@[Date Released]]),TODAY()-[@[Date Received]],NA()) -- this calculates the number of days open for still open items.

The #NA keeps the formulas in the bucket calculations from calculating.
Column H is =XLOOKUP([@[Closed Date Difference]],Table2[Days],Table2[Buckets],"Over 30",1)
Column I is =XLOOKUP([@[Open Date Difference]],Table2[Days],Table2[Buckets],"Over 30",1)

I'll explain XLOOKUP below. First of all, this explains all: https://www.howtogeek.com/439286/how...crosoft-excel/.

The lookup sheet contains a table for the buckets. The first two columns are used to look up the buckets, then next two have formulas for the data for the plots.

Here is one of the XLOOKUP formulas again: Column H is =XLOOKUP([@[Closed Date Difference]],Table2[Days],Table2[Buckets],"Over 30",1)

XLOOKUP takes a number of parameters but the first couple are:
- Look for this
- In this column
- Return the value found in this column
- What to do in case of an error
- What kind of a match do I want

So we look for the value found on the current line in the column labled Closed Date Difference (the @ means "look at this line")
Try to find it in the Days column in Table2
Return the matching value in the Buckets column in Table2 (No @ and just brackets means look at the whole column)
If there is an error, show the string "Over 30"
The 1 means look for an exact match and if you don't find it go back to the next highest value

For example, if 16 is entered, there isn't an exact match. The next highest value in the days column is 30, so use the bucket associate with that value.

If 45 is entered, there is NO next higher value. So there is an error. According to the formula, if there is an error show "Over 30"

I just noticed that you have Excel 2010 - you have tables, you may or may not have XLOOKUP. If you do not, then the formula obviously will not work. We can accomplish the same thing with MATCH and INDEX, but the formula becomes more complicated.