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?