Flexible X axis VBA/Macro generated

  • Thread starter Thread starter duncan beech
  • Start date Start date
D

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
 
Back
Top