Tech Support Guy banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
102 Posts
Discussion Starter · #1 ·
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 :rolleyes: 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?
 

·
Registered
Joined
·
102 Posts
Discussion Starter · #2 ·
Think I've been able to answer my own question through further digging in the past 24 hours. Just in case somebody else has this issue:
Inputting the named ranges in just the Chart Data Range field under Select Data Source isn't sufficient; you have to click on the series and put the named ranges in there individually. The range in Chart Data Range will show absolute values, but will nonetheless update according to the dynamic ranges.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top