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
|
|||
|
|||
Using a Macro to automate Charts
Good Day,
How can I use a Macro to create charts which would have different series length. Thus, it would create a chart for 10 yr period then witha change of data re-create a chart for a 2 yrs period ...and so on. Thanks for all your help Llednar |
#2
|
|||
|
|||
Using a Macro to automate Charts
[This followup was posted to microsoft.public.excel.charting and a copy
was sent to the cited author.] For a non-programmatic solution check the the 'Dynamic Charts' page of my web site. -- Regards, Tushar Mehta MS MVP Excel 2000-2003 www.tushar-mehta.com Excel, PowerPoint, and VBA tutorials and add-ins Custom Productivity Solutions leveraging MS Office In article , randellj1 @hotmail.com says... Good Day, How can I use a Macro to create charts which would have different series length. Thus, it would create a chart for 10 yr period then witha change of data re-create a chart for a 2 yrs period ...and so on. Thanks for all your help Llednar |
Thread Tools | |
Display Modes | |
|
|