Excel check box with graph

[arnab0711]

Hi,
I have this excel graph,where I have 2 check boxes,I want to create a formula,where on clicking on the check box we will show the line chart,if the line chart is not checked it won't show.

[LJMetzger]

Hi arnab0711,

I don't think you can do what you want with a formula.

If you made 3 copies of the chart, one with ASN, one with MRNs, and one with both (all superimposed on each other), it would be relatively simple to hide the two unwanted charts using VBA and your existing CheckBoxes.

Lewis