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)
Thank you for your reply.
I registered the filter function you told me in the name manager.
Then, after selecting data in the graph,
Click Edit on the legend item (series) and insert the name manager item into the series value.
I did that first, but it doesn't work well.
Can you tell me a more specific formula and where to insert it?
Thank you for your kindness.
