1) Won't the charts appear differently as data is appended to the
series? Or is there a difference I don't understand?
2) You can set up dynamic ranges that contain only the non blank part of
the data range, and chart these. Here's an overview, with examples and
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services