MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Add to chart area


Posted by Jeff on November 02, 2001 9:10 AM

I have a weekly report. Each week there will be additional data. I need to chart this data. Is there a way to set up a Macro that will automatically add the new data to the ChartArea every week?

Thanks for any help.


Posted by Mark W. on November 02, 2001 9:34 AM

Use dynamic, named ranges in your chart's SERIES function (nt)

Posted by Mark W. on November 02, 2001 9:35 AM

Or, chart from a PivotTable (nt)

Posted by Jeff on November 02, 2001 12:29 PM

Re: Use dynamic, named ranges in your chart's SERIES function (nt)

I'm sorry for the lack of know-how, but how do you make a Range dynamic?

Posted by Juan Pablo on November 02, 2001 12:37 PM

See http://www.beyondtechnology.com/geeks007.shtml