Repeat this step to draw another checkbox.Ĥ. Click Developer > Insert > Check Box (From Control). Then type below data into a blank range, supposing here, type 2018 into cell A6, TRUE in the cell B6, 2019 into cell A7, TURE in cell B7.Ģ0 are the row header of the data that will be used as series in the chart.ģ. Firstly, please arrange the data range as below screenshot shown:Ģ. Supposing there are two series in the chart, check checkbox1 to display series 1, check checkbox2 to display series 2, and both checked, display two series as below screenshot shown.ġ. In this case, you may want to show the series by checking the checkboxes. In Excel, we usually insert a chart for better displaying data, sometimes, the chart with more than one series selections. Create an interactive chart with series-selection checkbox in Excel
0 Comments
Leave a Reply. |