Defining chart series using named ranges

[perkin_warbeck]

I have two named ranges (defined in Name Manger) called  xValues and yValues.  I have a Chart of type scatter plot and I want to use these named ranges to define the Series X values and Series Y values.  What is the correct syntax?  Everything I try is flagged as an error.

[#2 · Accepted solution]

@perkin_warbeck 

You can use either

'Sheet 1'!xValues

and

'Sheet 1'!yValues

where Sheet 1 is the name of the sheet containing the ranges, or

'My Workbook.xlsx'!xValues

and

'My Workbook.xlsx'!yValues

where My Workbook.xlsx is the name of the workbook.

[#3]

@Hans Vogelaar Thank you!  That is exactly what I was looking for.