Series Value in an Excel Chart using named reference

Question

Hi,Trying to use a defined name for a Series value in an excel chart.&nbsp; Doesnt work.&nbsp; Using Office 365 on windows.Error shows:This is how the named reference is defined:&nbsp;Why doesnt named reference work?&nbsp; Is there another method supposed to be used?

patrick2788 · Answer

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

Forum Discussion

Series Value in an Excel Chart using named reference