Easily create an interactive line chart with checkboxes in Excel
Kutools for Excel
When comparing many sets of data with a line chart, too many mussy polylines in the chart will disturb the data analysis. The Check Box Line Chart utility of Kutools for Excel helps easily create an interactive line chart with checkboxes in Excel. The checkboxes control the data series in the chart, when unchecking a checkbox, the corresponding data series will disappear from the chart; when checking it, the data series will reappear.
Let’s see how to apply the Check Box Line Chart feature to create an interactive chart with checkboxes in Excel.
1. Click Kutools > Charts > Category Comparison > Check Box Line Chart. See screenshot:
2. In the Check Box Line Chart dialog box, you need to configure as follows.
Then the interactive line chart is created. You can check or uncheck the checkboxes to show or hide the data series in the chart based on your needs. See the below demo.
Note: Click the Example button in the Check Box Line Chart dialog box will open the example workbook.
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.