Auto date range updating in Charts

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I would like to know how to write a formula that can be
typed into an excel chart's category labels box and series
values boxes to search for and update ranges to a specific
range, such as one year's worth of row entries. In this
way, each time a new date and set of entries are made into
the spreadsheet, the accompanying chart would update to
the new range (last date).

I have tried using named formulas to accomplish this, but
I have so many spreadsheet in the workbook, that this
becomes unwieldy.

Any suggestions would be greatly appreciated.

thanks,
 
Hi Dave,
I have tried using named formulas to accomplish this, but
I have so many spreadsheet in the workbook, that this
becomes unwieldy.
Click to expand...

That's the only way to do it, I'm afraid. If you have Excel 2003 and
convert the data ranges to the new List areas, in which case any charts
based on the list will auto-update, but even then, you are *not* able
to specify 'Plot the last n items in the list'

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk
 
Thanks. Not the news I was hoping for, but thanks.
-----Original Message-----
Hi Dave,


That's the only way to do it, I'm afraid. If you have Excel 2003 and
convert the data ranges to the new List areas, in which case any charts
based on the list will auto-update, but even then, you are *not* able
to specify 'Plot the last n items in the list'

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

.
Click to expand...
 
Back
Top