I am using a date by month setup as one of my filter fields in a pivot chart. It displays the weeks in my chart by number (example The first week in January displays as a "1" instead of using dates. I was hoping to be able to use this field to list the dates included in my report automatically instead of me manually adding them(writing). I am very new to access pivot charts, so please excuse my ignorance. Any suggestions?