What kind of interactive charts do you use? Share with me in the comment section, I’d love to hear from you, and please don’t forget to share this tip with your friends, I’m sure they will appreciate it.A progress bar is always a great way to visualize any kind of progress. I hope this tip will help you to get better at charting, but now, tell me one thing. Sometimes you feel that it’s a lengthy process but it’s a one-time setup that can save you a lot of time. In the end, I just want to say that with an interactive chart you can help your user to focus on one thing at a time.Īnd you can save a lot of space in the dashboards as well. You can also make some formatting changes to your chart if you want.ĭownload this sample file from here to learn more.
After that, select your data bars & click on “change chart type”.First of all, select your table and insert a column chart.Now, you can control your data with these option buttons.In format control options, link it to the cell A1 and click OK.After that, right-click on any of the buttons and select “format control”.Insert three option buttons and name them as following.Go to developer tab ➜ Control ➜ Insert ➜ Option button.For “2” it will show profit and market share for “3”. And when you enter “1” in the A1 table will show you data for target and achievement only. All the cells in this table are linked with A1.
0 kommentar(er)
