Best way to set up chart to capture new data after macro runs?
 

I have an XL 2003 workbook with four data sets next to each other on
Sheet 1. Because the Powers That Be want to see it vertically, I run
a macro that captures the range of each table and stacks them on top
of each other on Sheet 2.

I am creating a chart to go into Sheet 2, and I'm wondering what the
best way would be to make sure all of my updated data gets into the
chart series ranges. Can I use a Named Range as my X or Y data range,
then simply have my macro create the range names and let the chart
pick that up? Or should I use code to directly modify the chart's
data ranges?

Ed