How to enter a date range to update a pivot table? Excel 2013 1

[MattGreer]

I have a pivot table (Excel 2013) that is selecting data from an Access database. I would like to be able to manually enter a date range on the spreadsheet and have the pivot table update itself based on those entries. Can this be done? I realize I can click on the Pivot Table field in Excel, but having the date on the spreadsheet itself is beneficial.

Thank you for your help!



Thanks!!


Matt

 

[SkipVought]

Hi,

Are you prepared to code in VBA?

If so, post this question in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MattGreer]

Thanks for the response.

I don't know what Microsoft did in their 2013 products, but I made a chart based off the pivot table and it's incredibly easy to use. I mean, it just all fell together exactly how I would have wanted it. I haven't worked with pivot tables in probably a decade so my knowledge is zippo. I'm quite pleased at the moment.

But I have a new request now. Is there a way to get date range that I select automatically put into the chart title? I am prepared to do some VBA if needed; I'm comfortable with that.

Thanks!!


Matt

 

[SkipVought]

Great!

You can probably do that on the sheet.

Is there a PivotField selection cell that contains either the start or end date selected?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MattGreer]

There's a button in the bottom left of the chart that is looking at the date field in the database, called "EntryDate". I click on that, and select the date range that I want to display. Is that a PivotField? I also have the PivotTable Field list sitting on the right side of the spreadsheet.

Thanks!!


Matt

 

[SkipVought]

I'm guessing that you have grouped your dates and your PivotField is in a Report Filter (used to be called a PageField)

So you make a selection in the Report Filter and your chart changes accordingly.

In the PivotChart, 1) SELECT (do not select in) the TITLE object, 2) enter an EQUAL character, 3) select the cell in the PivotTable Report Filer containing the date range, 4) ENTER.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}