Charts and Named Ranges

[KayWill]

I have a large spread sheet with a ton of data that changes monthly. I created a drop down (data validation) that allow the user to choose which "actions" they want charted. I am using the following to reference the drop down list to a range:

=IF(ActionList="","",IF(ActionList='Analytics All Mobile App Data E'!A2,'Analytics All Mobile App Data E'!A3:B455,IF(ActionList='Analytics All Mobile App Data E'!C2,'Analytics All Mobile App Data E'!C3:D455,IF(ActionList='Analytics All Mobile App Data E'!E2,'Analytics All Mobile App Data E'!E3:F455,"No Data to Chart"))))

This is not working at all and I've tried researching and not sure what I'm doing wrong. I've used a similar formula to allow the user to choose certain criteria's to produce a set of data in certain ranges with no issue but I can't get the above to work. Can someone please help or direct me where I need to go?

 

[KayWill]

I have a large spread sheet with a ton of data that changes monthly. I created a drop down (data validation) that allow the user to choose which "actions" they want charted. I am using the following to reference the drop down list to a range:

=IF(ActionList="","",IF(ActionList='Analytics All Mobile App Data E'!A2,'Analytics All Mobile App Data E'!A3:B455,IF(ActionList='Analytics All Mobile App Data E'!C2,'Analytics All Mobile App Data E'!C3:D455,IF(ActionList='Analytics All Mobile App Data E'!E2,'Analytics All Mobile App Data E'!E3:F455,"No Data to Chart"))))

This is not working at all and I've tried researching and not sure what I'm doing wrong. I've used a similar formula to allow the user to choose certain criteria's to produce a set of data in certain ranges with no issue but I can't get the above to work. Can someone please help or direct me where I need to go?

I can send a copy of the spreadsheet if needed. Is @STEPHENR or @tzw1378 or @Zack Barresse available to respond or any other person familiar with dynamic charts?