• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Peltier Tech

Peltier Technical Services - Excel Charts and Programming

  • Peltier Tech Consulting
  • Peltier Tech Software
  • Peltier Tech Training
  • Peltier Tech Blog
  • Twitter
  • Facebook

Advanced Excel Charting with VBA

Tuesday, November 20, 2018 by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2023, All rights reserved.
 

The Advanced Excel Charting with VBA class is a fill-day, hands-on workshop. The student will learn best practices for working with VBA, and will be able to use VBA to automate routine tasks, both for the student and for others. This class is equivalent to Intermediate Automation of Excel with VBA, with examples and explanations focused on using VBA with charting.

  • 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

All classes offered by Peltier Technical Services have been developed by Jon Peltier of Peltier Tech. They assume an intermediate level of competency in Excel, and build on this base to develop strong skills. Attendees work on practical examples using their own notebook computers. Class materials include presentations and workbooks, as well as a handful of helpful utilities.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to print (Opens in new window)
  • Click to email a link to a friend (Opens in new window)

Posted: Tuesday, November 20th, 2018 under .
Tags: .
Comments: none

Peltier Tech Charts for Excel

Microsoft MVP Logo

Primary Sidebar

  • Peltier Tech Software
  • Peltier Tech Consulting
  • Peltier Tech Training
  • Peltier Tech Blog
  • About Peltier Tech
  • About Jon Peltier
  • Copyright and Licensing
  • Blog Comment Policy
  • Blog Privacy Policy
  • Guest Post Policy

Peltier Technical Services, Inc. Copyright © 2023 – All rights reserved.

Admin