Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or

Easily create an interactive line chart with checkboxes in 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.

2.1) In the Data range box, select the data series you will display in the chart;
2.2) In the Axis Labels box, select the axis labels data;
2.3) In the Legend Entries (Series) box, select the data you will display as the chart legend (where the checkboxes display);
2.4) Click OK.

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.

  If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps.


Productivity Tools Recommended
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.

Kutools for Excel

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.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase