Hi,

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

Peter Dacre wrote:
I have a bar Chart running showing calendar days available to a 'point' and I
have to increment this manually so that it shows from the current date. Does
anyone know how this (Y-axis) can be incremented daily automatically?

--

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