Where do I enter a named range for the data of a chart? Nothing I try seems to work.
Where do I enter a named range for the data of a chart? Nothing I try seems to work.
Hi NicholasL & Welcome to the Forum,
After you have created the named range (Ctrl + F3), you would enter the name range in the Chart Data Source dialogue box.
EDIT: Let me know if this sample helps?
Last edited by jeffreybrown; 07-31-2013 at 06:21 PM.
HTH
Regards, Jeff
The sample did help! My main issue was recognizing how to put the named range into the dialogue box, (the syntax being "='Sheet1'!MyNamedRange") but your sample even showed me how to make it more dynamic by referring to a cell which I can change the value of! Very nice! Thanks!
You're welcome…glad you have a workable solution and thanks for the feedback...
Thanks for the 'rep' also
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks