Nov 08 2020 12:10 PM
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.
Nov 08 2020 02:34 PM
SolutionYou 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.
Nov 08 2020 03:41 PM
@Hans Vogelaar Thank you! That is exactly what I was looking for.
Nov 08 2020 02:34 PM
SolutionYou 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.