Chart adjustable range

I

iperlovsky

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,
 

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

Odd Chart Format Results 1
Chart SERIES OFFSET 3
Clustered-Stacked-Column Combo Chart With Lines 2
Copying Named Ranges in Chart Series 1
Chart Wizard 5
User Selectable Series and Number of Series for Line Chart 2
Excel Chart auto data highlighting anomaly.... 1
Chart type for machine timing diagram? 3

Top