If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Flexible X axis VBA/Macro generated
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 |
#2
|
|||
|
|||
Flexible X axis VBA/Macro generated
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 |
Thread Tools | |
Display Modes | |
|
|