Excess Dates Under Filter Options

PrinceNeptune

Board Regular
Joined
Jan 30, 2006
Messages
209
Hello,

I needed to create a chart/dashboard utilizing mock data for a visual presentation. So I utilized fake date information "7/18, 7/19, 7/20, etc". I finished the charts/dashboards.

Then the real data came in. I blew out the old data and put in the new data. Now, the filters show all of the old mock dates, even though there is no data that matches the date. I'd like this filter to only show dates that actually have matching data (7/2, 7/8, 7/17). (See screenshot below).

I know that I could recreate the chart/dashboard, but it was a painstaking process to get every line and marker the correct color and width, so I'd prefer to avoid that unless it is truly my only option (in which case, I may just say screw it).

Any thoughts on a quick way to fix this?

Thank you for any help/suggestions.

1595617175351.png
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,264
Office Version
  1. 365
Platform
  1. Windows
The autofilter should only values that are in that column, so the first question is, are you sure those values are not in the column?
Also I suspect that they are actually text & not real dates.
 

PrinceNeptune

Board Regular
Joined
Jan 30, 2006
Messages
209
Hello Fluff,

The values were originally in the data set (column) when I created the pivot. I have since deleted those dates. It is like those dates are cached into the pivot/system, and I want to remove/refresh the cache.

The format of the cells is Date -> *3/14/2012 (Format)

Thanks for any additional thoughts you might have.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,264
Office Version
  1. 365
Platform
  1. Windows
You never mentioned anything about pivots & as I've never used them I cannot help any further.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,035
Messages
5,622,332
Members
415,894
Latest member
silverhaze

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top