How to Change Mr. Excel's Speedometer Drop Down to Date Ranges

[anthony.johnson]

I purchased the Mr. Excel dashboard bundle (great stuff by the way). I am using the Speedometer Dashboard 2007. On the dashboard tab, I am attempting to modify the drop down to specific date ranges of:
Yesterday, Today, This Week, Last Week, and Last Month. I changed the format on the data tab in column A to dates. I also changed the format on the drop down to dates. I have values for everyday this year.

I would like the drop down to only display the specific date ranges and no each individual date.

Hope this is clear, sorry if not. Appreciate anyones help. thank you in advance.

 

[Steve=True]

I don't own the software, but maybe you could try something like this:

=TEXT(A1,"m/d/y")&" - "&TEXT(A2,"m/d/y")