A chart is a perfect tool to present data in an understandable way.
But sometimes it sucks because we overload it with data.
I believe that when it comes to charting it should be neat and clean. The best solution to this problem is using interactive charts.
By using interactive charts in Excel, you can present more data in a single chart. And, you don’t even have to worry about all that clutter.
Yes, it’s a smart way.
Look at the below chart where I am trying to show target vs. achievement, profit, and market share.
Do you think this is the decent way to present it? Of course not.
And, now check out this, where have an interactive chart which I can control with option buttons.
So, what do you think? Are you ready to create your first interactive chart in Excel?
So, let’s get started.
I have split this process into three parts.
You need to use below table to create this chart. Please download this file from here to follow along.
Now, your interactive data table is ready.
So far so good.
Let me tell you how it works.
All the cells in this table are linked with A1. And when you enter “1” in A1 table will show you data for target and achievement only.
For “2” it will show profit and market share for “3”.
So next, you have to insert option buttons to automate value in cell A1.
Now, it’s time to get down to the real thing.
Congratulations! your interactive chart is ready to rock. You canalso make some formatting changes in your chart if you want.
Download this sample file from here to learn more.
In the end, I just want to say that with interactive charts you can help your user to focus on one thing at a time.
And, you can save a lot of space in the dashboards as well.
Sometimes you feel that it’s a lengthy process but it’s a one-time setup which can save your lot of time.
I hope this tip will help you to get better at charting.
Now tell me one thing. What kind of interactive charts do you use? Please 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.