Forum Discussion
Solved
Chart graphs that automatically change depending on the subject
In the mixed vertical graph, If the subject score is 0, I want to exclude it from the graph, and automatically add it to the graph when the subject score is added. Of course, the spacing is automa...
Have you tried the demo workbook that I attached to my previous reply? It should do exactly what you want.
How about named ranges and filter functions:
=FILTER(A2:K2, A3:K3<>0)