Dynamic chart invalid reference - will not let me chart

Without your spreadsheet attached to assist, the best I can do is provide an example.

I have defined dynamic named ranges using OFFSET. These ranges are named DATES_COLUMN and YCOL_1.
Under the 'Select Chart Data' option after right-clicking the graph, you can select to edit a range. Here you can define the Series name, Series X Value Array and Series Y Value Array

My X Value Array is:

Please Login or Register  to view this content.

My Y Value Array is:

Please Login or Register  to view this content.

I believe the workbook name is required when referencing a named range.

If you are still unable to get this to work, please post a spreadsheet and attach it to your post using 'Go Advanced'

Please Login or Register  to view this content.

Do you have a failure e.g. #!div in the cells?

What are the formulas that define these names?