Cloud Computing Insider Awards 2022: Vote for ONLYOFFICE

Create chart with no duplicate values

Hello, friends how to create chart without duplicate values?
I the case below I have multiple winners in one day. When I click nov for example it should show all dates for november but here it shows one date multiple times instead of one time. I tried doing it with pivot table but the chart doesn’t update automatically because range always stays at one place.

Hello @stanislav
I just send you example of file with chart and slicers via PM where multiple winners persist in one day. Please do not post the same question in different topics\chats.