Forum Discussion
Solved
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 valu...
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.
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.