Forum Discussion
Chart graphs that automatically change depending on the subject
- May 27, 2025
Have you tried the demo workbook that I attached to my previous reply? It should do exactly what you want.
Thank you for your reply.
I have a few more questions.
The maximum number of family members is 10,
and only the members with scores should be shown.
Just as brother1 and brother4 were not on the score sheet, there may or may not be scores in the middle.
That is, only members with scores should be
shown on the graph and reflected flexibly in the legend format.
In the case of brother1 and brother4, since they did not have scores,
they were omitted from the graph and legend format,
but they should be added to the graph and legend format again when they have scores.
And if one of the middle siblings is missing, the graph will also disappear, and the spacing should be adjusted automatically.
According to what you said,
the target is not added, the legend format is not automatically reflected, and when there is no score, the graph becomes blank.
I am very grateful for your kindness.
Have you tried the demo workbook that I attached to my previous reply? It should do exactly what you want.