One Date axis in pivot - multiple date fields

[wizmaster]

Hello Everyone,

I am struggling to figure out how to do this. I have data that has multiple data fields. From this data I am creating a pivot table and a corresponding stacked column chart. I wanted to create a date filter or slider that i can input the start and end date so i can only pull data that is applicable in the date range for both the pivot and chart. I was trying the mix/max function - but still unsure how I can the date axis on the graph to only show one date field.

Can you help?

Example.png

[JeteMc]

Perhaps the following will do what you want.
Add a column to the source data, populated using:

Please Login or Register  to view this content.

The associated pivot table/chart and timeline are modeled on Sheet1.
Let us know if you have any questions.

[wizmaster]

Thank you!!

[JeteMc]

You're Welcome. Thank You for marking the thread as 'Solved'. I hope that you have a blessed day.