I want to show 3 bars in a chart, lets say Academics, Production, and Learning
Y-Axis should have Week Numbers, Like week-1 to week-12
Values are in dates. Now the the query is, if any cell value is missing, that part of the bar must change it's color for instance, the bar is green and missing part, that little chunk is red.
No VBA please. Weeks in slicer is acceptable
Solved by A. Y. in 24 mins