Allow only 1 check box to be used at a time

[dawondr]

Happy Sunday all,

My title is not exactly what I'm trying to accomplish but close. On the attached Dynamic chart I have attached there are 3 checkboxes to display certain data. My issue is this, if I click the outside checkbox and the ISE checkbox at the same time that is OK, it gives me a comparison of the two data sets in a bar chart. Perfect. If I click just the total checkbox it gives me the total info of the outside and ISE, again perfect.
BUT
If I click all 3, it doubles all the numbers because total is total and outside + ISE also equals the total.
My Question,
-Is there a way to lock out a checkbox if another is active?
if 1 then no 2 or 3. if 2, 3 is OK but 1 is not. if 3 then 2 is ok but 1 is not?
-If it can’t be locked can it do something like; If #1 has a check and you try to enter #2 a red error message could come up saying these two choices together the data will be inaccurate. I’m thinking this might be done in conditional formatting but I can’t figure out how.
If option one is doable and easy, is it also possible to have an error message like in my second idea so people will know why they can’t click that second box? This would be my preferred fix but I am open to any other option you may have to accomplish this. Thanks in advance for your time and help.

Dave

[popipipo]

Use option buttons

[dawondr]

Thanks, I do like it but the one limitation is that I can only pick one of the 3 at a time. I was hoping to only be able to do total OR outside only, inside only or outside and inside

[popipipo]

What about this solution?

[dawondr]

I think this option will do, thank you very much for your help