![insert check box word 2018 insert check box word 2018](https://cdn.extendoffice.com/images/stories/doc-word/insert-checkbox-symbol/doc-insert-checkbox-001.png)
In the cell B12, type this formula =IF($B$7,B4,NA()), then drag the auto fill handle right to fill all cells of the data range with this formula.ĩ. In the cell B11, the first blank cell of the pasted data range, type this formula =IF($B$6,B3,NA()), then drag the auto fill handle right to fill all cells of the data range with this formula.Ĩ. Then delete all data range excluding the headers. Copy the data range, here is A2:M4, and paste them to a blank cell, for instance cell A10. Now when the checkboxes are checked, the text in B6 or B7 will display TRUE, or display FALSE.Ħ. Repeat this step to link the checkbox 2019 to cell B7. Then right click at checkbox 2018, select Format Control from the context menu, in the Format Control dialog, in Cell link textbox, choose the cell B6 that you typed TRUE in step 2, and click OK. Repeat this step to change the name of checkbox 2.ĥ.
Insert check box word 2018 series#
Then right click at the first checkbox, choose Edit Text from the context menu, then change the name of the checkbox 1 to 2018 (the first series name you will use in chart). 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.
![insert check box word 2018 insert check box word 2018](https://www.howtogeek.com/wp-content/uploads/2017/11/wcb_3.png)
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