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.
I hope this helps as a solution! Let me know if you need more details or assistance.
In B1:
=SEQUENCE( ,10)
to make numbering.
In B12:
=FILTER(B1:K1,B7:K7>0)
to filter index which total is > 0.
In B13:
=CHOOSECOLS(B2:K6,B12#)
Test: