Flexible X axis VBA/Macro generated

[duncan beech]

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

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

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

Duncan Beec

 

[Jon Peltier]

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