Pivot Chart Question

[calvinle]

Hi,

I have a pivot table that count all transaction processed by users for every single day.
Is it possible to limited the x asis to only show a limited of 5 recent days. Otherwise, the graph will be too large if I want to see all in details.

Thanks

[avk]

yes this possible. Attach your sample file.

[calvinle]

Hi,

Here you go:


Thank you.

[avk]

plz find attach file. Refer "Pivot" sheet.
In this sheet i have create another table with =today()-J3 (J3 is number of day)
column "L" to "Q" using vlookup formula.
In graph, you can select latest 5 days.

[calvinle]

plz find attach file. Refer "Pivot" sheet.
In this sheet i have create another table with =today()-J3 (J3 is number of day)
column "L" to "Q" using vlookup formula.
In graph, you can select latest 5 days.

Hi,

Your method will work on a fix data, however, my dat are dynamix.
Whenever a new transaction is processed, it will update the data table, so if I refresh the pivot table, it wont pick with the new value.

[xlnitwit]

Hi,

You could add a column to your source data using the formula =A2>=today()-4 then add this new column as a report filter in your pivot table and filter for TRUE values. When you refresh the pivot everything should update.