Hi,
I’m thinking how to do in the right way dynamic chart.
What I need is to have some control button/filter field/etc. when I can choose one of exercises and to show chart with only that one. Because when I get 50 exercises, below chart will be unreadable.
Could anyone help me?
For me, the best solution would be similar to
or
One way to do this is with Autofilter. Construct your graph to include all of your exercises. Add a column heading to the exercise column, select it, then choose Data/Autofilter. Activate the pull down in the Exercise column and un-check the All box. Then select the exercise(s) to be displayed on the graph. Only the selected exercises will be displayed.