Hi All,

Im wondering if there is an alternative to if and statements? I have a chart that runs from 2 drop down menus which link to one another, then have radio buttons which lets the user select for specific information.
I am currently using if and statements but this gets to a point where it can get very large or i will use up the amount of if and statements excel will let me use.

I have got the chart working so that when the user clicks on the drop down and selects their information, then when they select a radio button it displays the information on the chart, however as stated, its using alot of it and statements and was wondering if there is an alternative?

My chart is dynamic hence the reason for formulas to change the chart when the user selects their data.

Many Thanks