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