Ask Your Question

Dynamic charts

asked 2016-06-08 11:14:15 +0200

ktatar156 gravatar image


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?

image description

For me, the best solution would be similar to image description or image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-06-08 21:59:42 +0200

w_whalley gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-08 11:14:15 +0200

Seen: 665 times

Last updated: Jun 08 '16