"Doug Glancy" wrote in
:

I've just started using named ranges in charts. One thing I've seen
is that I can't just enter the named range. First I enter a normal
range, e.g., MySheet!$A$1:$A$5 and then I go back and replace the
$A$1:$A$5 with the named range. Or at least that's what I think I did


Doug, that's pretty much what I'm trying to do. I'm modifying an existing
chart. Actually I'm destroying it over and over!

cheers

Marc