Slight twist on dynamic ranges

J

jashburn13

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic (?) chart 0
Data Range Question 1
Dynamic chart 0
Dynamic stacked bar chart not working 3
Dynamic chart ranges (slight variation) 2
Can you make a chart's data *always* refer to a dynamic range name? 2
Chart adjustable range 2
One Range, Two Colors 4

Top