View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
jashburn13 jashburn13 is offline
external usenet poster
 
Posts: 8
Default 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!