Help with If formula regarding xy scatter chart

**jkr4250** · 09-07-2011, 03:19 PM

Alrighty be patient I'm a new guy so i apologize in advance... so i have a chart with existing data on it and i have a cell that i need to plot but only if it that cell "passes." It passes when it is lower than a given number/cell. Hopefully this isn't too general.I'm Know how to set it to whether or not it passes or not but after that i get stuck so please help a guy a out. Thank you so much for taking the time to read this.

**jeffreybrown** · 09-07-2011, 03:22 PM

Hello & Welcome to the Board,

If you do not want a point to plot then use the NA() function.

Example: =IF(A1<B1,"passes",NA())

**jkr4250** · 09-07-2011, 03:29 PM

JeffreyBrown:

Well thank ya and alrighty so that will not plot if it passes? Because if it passes i need it to plot in the chart.

**jeffreybrown** · 09-07-2011, 03:38 PM

Here is an example.

This uses a check box in column D (Double click), but you can restructure the If statement for your needs.

**jkr4250** · 09-08-2011, 09:02 AM

Thanks so much JeffreyB

Alrighty Cool Just one more little question How did you get the check marks there? If i put an a in the corresponding box i get it to to be hidden from the chart but a check mark will look better.

Thanks again man i owe ya a six pack or something haha

**jeffreybrown** · 09-08-2011, 01:37 PM

You're welcome...Glad to be of some help

For the check mark >> enter an "a" >> change the font to Marlett.

Maybe this example will also help...

**jkr4250** · 09-08-2011, 01:48 PM

WOW man thanks i feel like ten times smarter haha umm whats the process of being able to make the check mark appear and disappear by just clicking on it all i can do so far is just type it in which works fine but clicking is a lot easier

**jeffreybrown** · 09-08-2011, 03:49 PM

Did you look at the first attachment?

If you do you will find a double click event in the VBA...

To get to the VBA >> Alt + F11 >> Alt + Q to close the VBA

This should help also...

http://www.rondebruin.nl/code.htm

**jkr4250** · 09-09-2011, 09:41 AM

Ok i think i am missing something in the sample of check boxes with mutual and stuff i went into VBA and tried to copy i did exactly what they said but it doesn't show up in my macro list.
and i noticed in your two check box examples you didn't have a module but instead the sheets had the code in them. so i guess my question is exactly how do i set all that up if possible I'm sorry for asking so many questions. I would just like to get this to work

thanks again :/

**jeffreybrown** · 09-09-2011, 12:18 PM

Yes this is worksheet code which needs to be installed in the sheet module.

Maybe this article will help...

http://vbaexpress.com/kb/getarticle.php?kb_id=879