Is there a way to set a graph's range to expand automatically?
I'm working on a sheet that will have new information added daily. No information will be deleted, so the range of cells it covers will be constantly expanding. How do I set the graph so that it will automatically add in the new information, without my having to go in and expand the range of cells?
I did some google research and found something on a SERIES formula, but I'm not quiet sure on how it is supposed to work, and whether or not it will work in 2007.
Thanks!
Last edited by just_some_guy; 03-17-2010 at 07:01 PM.
Have a look here:
http://www.beyondtechnology.com/geeks007.shtml
You'll need to set up a dynamic named range
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks