SOLVED

Defining chart series using named ranges

%3CLINGO-SUB%20id%3D%22lingo-sub-1865255%22%20slang%3D%22en-US%22%3EDefining%20chart%20series%20using%20named%20ranges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865255%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20named%20ranges%20(defined%20in%20Name%20Manger)%20called%26nbsp%3B%20%3CSTRONG%3ExValues%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EyValues%3C%2FSTRONG%3E.%26nbsp%3B%20I%20have%20a%20Chart%20of%20type%20scatter%20plot%20and%20I%20want%20to%20use%20these%20named%20ranges%20to%20define%20the%20Series%20X%20values%20and%20Series%20Y%20values.%26nbsp%3B%20What%20is%20the%20correct%20syntax%3F%26nbsp%3B%20Everything%20I%20try%20is%20flagged%20as%20an%20error.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1865255%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1865455%22%20slang%3D%22en-US%22%3ERe%3A%20Defining%20chart%20series%20using%20named%20ranges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865455%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382386%22%20target%3D%22_blank%22%3E%40perkin_warbeck%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20either%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E'Sheet%201'!xValues%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eand%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E'Sheet%201'!yValues%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewhere%20Sheet%201%20is%20the%20name%20of%20the%20sheet%20containing%20the%20ranges%2C%20or%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E'My%20Workbook.xlsx'!xValues%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eand%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E'My%20Workbook.xlsx'!yValues%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewhere%20My%20Workbook.xlsx%20is%20the%20name%20of%20the%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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 Replies
Best Response confirmed by perkin_warbeck (Contributor)
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.

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