I'm fighting with dynamic charting in Excel 2007. I just about found my way in 2003 but having to learn it again now, hehe I've created my ranges (which I can see just fine in the Name Manager) and if I go to my chart and put the name of the range in the Chart Data Range, then it works just fine. However, if I close the Select Data Source window and then reopen it, the dynamic range I put in has been replaced with absolute values. How can I make it "stick" so that my chart data will remain dynamic? Am I missing something really obvious here?