Show line conditionally - Line Chart

[idrisb59]

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

[broro183]

hi Idris,

Jon's site index at the below link is a very good starting point to a huge amount of useful info:
http://www.peltiertech.com/Excel/Charts/ChartIndex.html

Also, it is often easier for people to help when you provide a zipped workbook as an example file. This can be done by clicking on the "paperclip" or the "manage attachments" buttons on the Reply page.

hth
Rob

[idrisb59]

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.