What are Charts and Graphs in Excel?Ĭharts and graphs are data visualization tools that help elevate your data. And if you want to take it a step further, you get to use the Excel ChartExpo add-in to professionally create charts for your audience.īefore diving into the ways of creating a chart in Excel, you’ve got to get a good grasp of what graphs and charts are - here’s a brief overview of these data visualization tools. Simply put, you can make charts in Excel using any Excel version. 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.Well, the process is relatively straightforward - and you can accomplish it using Excel 365, Excel 2016, Excel for mac, or Excel 2013. 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.

Now for profit and market share, change the chart type to the line with markers and tick the secondary axis for both.Ĭongratulations! your interactive chart is ready to rock.

Go to Design Tab ➜ Design ➜ Change Chart Type.

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.

How to plot a graph in excel 2016