I can't be sure without seeing the file you're working on but are you including a sheet name in the chart when using the named range?
E.g. for the chart data range this might work:
but this might not![]()
=Sheet1!MyNamedRange
![]()
=MyNamedRange
I can't be sure without seeing the file you're working on but are you including a sheet name in the chart when using the named range?
E.g. for the chart data range this might work:
but this might not![]()
=Sheet1!MyNamedRange
![]()
=MyNamedRange
<--- Please click the star to say thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks