Is there any way to incorporate an OFFSET function or a named range into an
Excel chart so that the chart series' reference an automatically adjustable
range of cells? Charts are generically set up to reference a fixed range,
such that if you add an additional row to the end of the series you must
manually adjust the chart to capture the new row. In my example the beginning
of the data series is fixed at a beginning date and new rows of information
are periodically added as time passes. Being able to have the chart
automatically reflect this rather than manually adjusting the chart would be
a big time saver.

Thanks,

Hi,

Yes. Have a read of Jon's blog, which includes links for more information.
http://peltiertech.com/WordPress/200...ynamic-charts/

Cheers
Andy

iperlovsky wrote:
Is there any way to incorporate an OFFSET function or a named range into an
Excel chart so that the chart series' reference an automatically adjustable
range of cells? Charts are generically set up to reference a fixed range,
such that if you add an additional row to the end of the series you must
manually adjust the chart to capture the new row. In my example the beginning
of the data series is fixed at a beginning date and new rows of information
are periodically added as time passes. Being able to have the chart
automatically reflect this rather than manually adjusting the chart would be
a big time saver.

Thanks,

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Very helpful. Thanks.

"Andy Pope" wrote:

Hi,

Yes. Have a read of Jon's blog, which includes links for more information.
http://peltiertech.com/WordPress/200...ynamic-charts/

Cheers
Andy

iperlovsky wrote:
Is there any way to incorporate an OFFSET function or a named range into an
Excel chart so that the chart series' reference an automatically adjustable
range of cells? Charts are generically set up to reference a fixed range,
such that if you add an additional row to the end of the series you must
manually adjust the chart to capture the new row. In my example the beginning
of the data series is fixed at a beginning date and new rows of information
are periodically added as time passes. Being able to have the chart
automatically reflect this rather than manually adjusting the chart would be
a big time saver.

Thanks,

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info