Series Value in an Excel Chart using named reference

Copper Contributor

Hi,

Trying to use a defined name for a Series value in an excel chart.  Doesnt work.  Using Office 365 on windows.

Fred_D_19460_1-1704810106449.png

Error shows:

Fred_D_19460_2-1704810163710.png

This is how the named reference is defined:

Fred_D_19460_3-1704810215388.png

 

Why doesnt named reference work?  Is there another method supposed to be used?

1 Reply

@Fred_D_19460 

This is the syntax Excel is looking for where: X_n and Y_steps are my named items.

 

Patrick2788_0-1704815579729.png