Skip the macros, and try this approach:

http://peltiertech.com/WordPress/dynamic-charts/

At the end of the tutorial are links to specific examples.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"duncan beech" wrote in message
...

I am trying to create a chart showing a payment profile with a fixed
start date but variable end. Manually, simple, select all cells with a
date before the end date and that is X axis, and series data for
appropriate cells.

How can I create an X axis range which only goes to the end year? The
same process will presumably apply to series data also.

This cannot be so difficult I would have thought. Am I missing
something?

Duncan Beech




--
duncan beech