"Jon Peltier" wrote in message
...
You could look into dynamic named ranges for your source data ranges. Here
are a few examples and a lot of links:
http://peltiertech.com/Excel/Charts/Dynamics.html
Thanks, Jon.
I've actually tried several of the dynamic range tutorials without luck.
They all seemed to be geared toward a graph with data values and labels, but
I haven't been able to taylor them to work with my scenario. Could you,
perhaps, provide a very, very simple dynamic range solution for just a
column of data that will change in length (i.e., no labels, no column
headers (and thus, offsets), etc.) Just a simple column like:
4
3
8
1
6
1
4
whose area graph would automatically expand if you added two elements:
4
3
8
1
6
1
4
8
1