A autoguy57 New Member Jan 20, 2021 #1 Hello, I am trying to create a chart to track a weekly winner out of 10 departments. I want to show which department won for WK1, WK2, WK3, etc., any help would be appreciated! Attachments Winner Chart.xlsx 19 KB · Views: 18
Hello, I am trying to create a chart to track a weekly winner out of 10 departments. I want to show which department won for WK1, WK2, WK3, etc., any help would be appreciated!
p45cal Well-Known Member Jan 23, 2021 #3 By 'chart' I'm assuming Table. Power Query solution at cell A14. Right-click the table and choose Refresh to update. Attachments Chandoo45621Winner Chart.xlsx 29.7 KB · Views: 22
By 'chart' I'm assuming Table. Power Query solution at cell A14. Right-click the table and choose Refresh to update.