Thread: Show line conditionally - Line Chart

Is there a way to display or not display a line on a line chart, based on a true / false value ( Checkbox )

I did look around and through various threads and the common way is to duplicate the columns with an IF condtion and use the NA() if false.

I am using NAMES to define the lines and tried putting a IF condition , excel did not like it , could be the way I did it.

Thanks

Idris

Attaching Zip file.

This one does not have names.

I would like to show the below lines Conditionally.

Sol
Sol90
Sol120
Sol180

The most common way is to use an IF condition and if false end it with , NA().

This requires replicating all the columns and I have a total of 110 columns / lines in the full blown version.

Thanks.

Idris.