Chart to reference specific dates

[jme1013]

Hello, I have a chart that references a table based on one of the columns.

I would like the chart to only reference the data in the table from the last 30 days.

This is the current formula I'm using that works.

=COUNTIF(Table2[[#All],[Type]],"Dropped Part")

This returns a value of 8 since there are 8 instances of dropped parts in the entire table.

The first column in the table is the date.

I tried to attach the worksheet, but I kept getting "Upload Failed"

Thanks in advance.

[Glenn Kennedy]

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[jme1013]

That's the way I was attempting to attach it. I've never had this issue before???

[Glenn Kennedy]

How big is the file (theres a 1 MB limit)??

[jme1013]

And there you have it..... 2.5MB

[humdingaling]

you shouldn't be attaching the whole file

trim file to show sample, just enough to get the gist of the problem

[jme1013]

Ok, I had to create a new file.

Here's a much simpler version of the same thing.

Current formula

=COUNTIF(Table1[[#All],[Type]],"Dropped Part")

I want it to return a value for "Dropped Part" but only if it is from the last 30 days.

The 1st column in Table 1 is the date column.

[Glenn Kennedy]

Using COUNTIFS:

=COUNTIFS(Table1[Type],"Dropped Part",Table1[Date],">="&TODAY()-30)

and similarly for the other two.

[jme1013]

Perfect Sir. Thank you. I was doing that formula, I just had everything in the wrong order. Thank you again.

[Glenn Kennedy]

You're welcome!