Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Automated Charts

Automated Charts

ResolvedVersion 2003

Thu 14 May 2009, 17:15 Delegate Ben said...

Ben has attended:
Excel VBA Intro Intermediate course
Access Introduction course

Automated Charts

I am trying to create a macro which will create a line chart out of the rightmost 8 data points in a series where each week a new data point is added to the end. How do I write a script to select only these points prior to activating the chart wizard?

Tue 19 May 2009, 09:15 Trainer Jacob said...

RE: Automated Charts

Hi Ben

To provide an thorough working explanation specific to what you are trying to do is beyond the scope of this forum.

However, we actually cover charts in our 2 day Excel VBA advanced course please click here for more information.

Regards

Jacob

Tue 26 May 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

Automated Charts

Automated Charts

RE: Automated Charts

Excel articles

Excel tip:

Closing Multiple Workbooks quickly