98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Automated Charts
Automated Charts
Resolved · Low Priority · Version 2003
Thu 14 May 2009, 17:15Delegate 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:15Trainer 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 information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Currency formatCtrl+Shift+$ applies the Currency format, with two decimal places |
