Error trying to use a named range to define series x values

I have a chart in which I am trying to use a named range (X1Values) to define the Series X values for Series1
Edit Series.png
The range X1Values appears in Name Manager thus
Name Manager.png
but this is showing the following error message when I attempt to use it as shown in the first image
Error message.png
If I set the range to Calculations!$B$3:$B$51 (the same range as X1Values) all is well. The chart is embedded on Sheet1 (aka "Parameters") and the range is on Sheet3 (aka "Calculations").

Try it with INDIRECT, i.e.:

=INDIRECT(X1Values)

or you may need to put quotes around the name:

=INDIRECT("X1Values")

Hope this helps.

Pete

I tried that after posting and it doesn't work. Thanks

Both those give "Function isn't valid"

You are right, Trevor's syntax is working (I don't know why it didn't work when I tried it the first time - I must have done something wrong). Two points though:

1. When I go back to edit the series, it is shows the filename of the workbook at the beginning of the definition and I can't see the full definition.
2. I don't understand why the Calculations! prefix is required when the scope of X1Values is "Workbook".

Lastly, I will need to see how I can do this in VBA - but I'll work on that later.

Thanks to everybody (especially Trevor, thank you Trevor)

Thank you, that is incredibly helpful (I didn't know about either of those things)