Slight twist on dynamic ranges
 

If I have a vertical list of Types, Dates & Weights, how can I chart
the dates vs. weights if the start and end cells are changing i.e. the
range of a certain type may be A15 to B25 one time and A16 to B27 after
new data is added. Manually changing the chart ranges whenever new
data is added to the list is getting to be a pain in the butt. Thanks
for any help or ideas!

Slight twist on dynamic ranges
 

Hi,

You need to also specify the number of rows to use in the offset formula.

See here for details on dynamic ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html

Cheers
Andy

jashburn13 wrote:
If I have a vertical list of Types, Dates & Weights, how can I chart
the dates vs. weights if the start and end cells are changing i.e. the
range of a certain type may be A15 to B25 one time and A16 to B27 after
new data is added. Manually changing the chart ranges whenever new
data is added to the list is getting to be a pain in the butt. Thanks
for any help or ideas!


--

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