Dynamic Named Range for a Chart
 

I have a dynamic named range for a data set that I want liked to a chart.
When I enter the range "Data" in the data range for the chart it accepts it
but when I click back in the data range, the named range is gone.
How can I retain the named range so the chart will update if my data set
expands?

Dynamic Named Range for a Chart
 

You have to input dynamic named ranges in the series tab (under X and Y
values), not the data range tab. Note that syntax is:
='My Workbook.xls'!MyRange
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"PFLY" wrote:

I have a dynamic named range for a data set that I want liked to a chart.
When I enter the range "Data" in the data range for the chart it accepts it
but when I click back in the data range, the named range is gone.
How can I retain the named range so the chart will update if my data set
expands?