Inconsistent chartview

[Paul Bergholtz]

Hi all!
I have a problem with a chart. I attached a file which I hope could better describe my problem.
Anyway! When I check one of my checkboxes, data will be copied from row 10-12 to row 22.
The graph reads the data from 22 without any problem. But after I've checked the checkboxes more than twice,
the graph-type is changed! Quite annoying...I'm sorry for the bad description, but you'll get what I mean if you try the script.
I don't know if it's me or excel, but I would be most grateful if someone could help me out here.

Thanks in advance!

//Paul

 

[p45cal]

I think you have to deal with the situation where no checkbox is ticked.
Try changing the formula in the cell N22 to:
=IF(M1=TRUE,INDEX(N10:R12,1,0),IF(M2=TRUE,INDEX(N10:R12,2,0),IF(M3=TRUE,INDEX(N10:R12,3,0),{0,0,0,0,0})))
or:
=IFERROR(INDEX(N10:R12,MATCH(TRUE,M1:M3,0),0),{0,0,0,0,0})

 

[Paul Bergholtz]

Yes! It works! Thanks a lot, p45cal.
Just curious; why did it work with the {0,0,0,0,0} after the formula?

Regards,
//Paul

 

[bosco_yip]

Yes! It works! Thanks a lot, p45cal.
Just curious; why did it work with the {0,0,0,0,0} after the formula?

Regards,
//Paul

{0,0,0,0,0} means for 5 columns of 0. If no checkbox is ticked.

And

You may use this formula, If the checkbox more than 3 and the number of source rows more than 3:

=IFERROR(INDEX(N10:R100,MATCH(TRUE,M:M,0),0),{0,0,0,0,0})

Or

=IFERROR(OFFSET(N10,MATCH(TRUE,M:M,0)-1,0,,5),{0,0,0,0,0})

Regards

 

[Paul Bergholtz]

Ah, ok. Thank you! Really appreciate your help. There's always something new to learn!

Regards,
//Paul

 

[bosco_yip]

Ah, ok. Thank you! Really appreciate your help. There's always something new to learn!

Regards,
//Paul

You are welcome.

Blessings