Advanced Excel Charting VBA Class

Developed by Jon Peltier of Peltier Technical Services, the Advanced Excel Charting VBA class is a hands-on experience, scheduled to take three to four hours. The class assumes an intermediate level of competency in Excel, and builds on this base to develop strong skills. Students work on practical examples using their own notebook computers. Class materials include presentations and workbooks, as well as a handful of helpful utilities.

Automating Excel Charting with VBA

Record Macros to Create and Format Charts Automatically
Understanding the VB Editor

Visual Basic Elements
Project Explorer, Properties Window
Object Browser, Immediate Window, Locals
VBE Options

Tweaking Recorded Macros
Debugging and Error Proofing

Errors in Recorded Macros
Error Trapping

Using a Dialog to Interact with Users

Let User Select Chart Data and Chart Position
Let User Select Chart Options from a Custom Dialog

Improve your Programming Technique

Variables
VB Structural Elements
The Chart's Object Model
Chart-Specific Coding Considerations
VBA Programming Tools

Modular (Reusable) Procedures
VBA for Charting Across Applications

Contact Peltier Tech

to get information on upcoming training programs,
to schedule a training program at your facility,
to customize a training program to meet the needs of your organization.

Contact Peltier Tech

Excel Chart Add-Ins | Training | Peltier Tech Blog