Solved: Dynamic charting in Excel 2007

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

StoryAngel

Thread Starter
Joined
May 29, 2002
Messages
102
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?
 

StoryAngel

Thread Starter
Joined
May 29, 2002
Messages
102
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top