Here is a list of steps you can take to troubleshoot named ranges not working in Excel charts:

1. Check to make sure the named range is in the referenced sheet
2. Check the formula of the named range for any syntax errors
3. Make sure the named range is a dynamic named range
4. Check to ensure the named ranges are not overlapping one another
5. Check the scope of the names to ensure that the chart and named range are in the same scope or directory