I have a dataset configured below: The chart is by day for 3 years so there are 1095 columns. Then the rows are customers and the numbers displayed are there daily balances. I would like to chart this where a user can select the months to view or days within a month. My challenge is when pivoting excel doesnt recognize the dates and instead treats them like discrete columns of data.
If I chart without a pivot then I do not see a way to add a filter or slicer to give the user a chance to select the days. What can I do?
1/1/2022 1/2/2022 1/3/2022 1/4/2022 1/5/2022 ...
Customer A 10 15
Customer B
Customer C
Customer D
Bookmarks