Forum Discussion
Defining chart series using named ranges
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.
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.
2 Replies
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.
HansVogelaar Thank you! That is exactly what I was looking for.
