Conditional Charting

[bigjdawg43]

I have three rows of data with which I would like create a scatterplot with 2 out of the 3 depending on a condition. Regardless of the condition, both charts will use the same Y axis (in this case, row 2). But depending on my decision cell (N4), I want to use either Row 3 or row 4 as my X axis. This seems like an obvious use of an IF statement but that doesn't seem to interact well with the SERIES function. Does anybody have any suggestions? Thanks.

[MrShorty]

The SERIES() "function" is not really a function like other worksheet functions -- it only looks like one. You cannot "nest" other functions/formulas inside of the SERIES() "function" like you can regular worksheet functions.

The way I would do this is have a helper row (row 5??) that will contain a suitable IF() [or other] function. =IF($N$4="use row 3",B$3,B$4) maybe. Then the X-values for the data series will point to this helper row.

If you find the use of the helper row extremely offensive and absolutely unacceptable, I could see using the OFFSET() function in a dynamic named range for the X values argument. This is a little bit different way to use the OFFSET() function to create dynamic named ranges for charts than the usual examples (involving counting functions), but it should be readily doable if you are familiar with the OFFSET() function (https://support.office.com/en-us/art...e-b4d906d11b66 ) and how to name ranges using the OFFSET() function https://support.office.com/en-us/art...2-ABD7FF379C64

Does that help?

[bigjdawg43]

Actually, I managed to figure this out by using a combo box, name manager, and CHOOSE function to basically toggle between the two different charts. Thanks for the help!