cancel
Showing results for 
Search instead for 
Did you mean: 

Using Checkboxes to Add/Remove Series on a Chart

Former Member
0 Kudos
67

Does anyone know how to use a checkbox to add/remove an entire row of data for a chart? I can easily do this for one column but I am interested in plotting or removing an entire row depending on the state of the checkbox.

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Conditional formulas in the data series.

So, if your cells currently have values like 1, $1.00, or 1048.41, they'll need to become...

A1 =IF($B$1=0, 1.01, "novalue")

A2 =IF($B$1=0, 2.02, "novalue")

A3 =IF($B$1=0, 3.03, "novalue")

Place a 0 in B1, then have a checkbox insert to B1.

The result is that the value will "disappear" when the checkbox is checked, and the chart will not render the data points.

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks! That works great!