Tabellab
Intermediate

Charts with VBA

Create, format and export Excel charts from code so every report looks identical every month.

7 lessons 56 min Certificate

The first lesson is free — no account needed.

About this course

Create, format and export Excel charts from code so every report looks identical every month. You work with ChartObjects and Charts, add a chart in VBA, feed it with SetSourceData, choose the chart type, set titles, axes and the legend, format series, and export a chart as an image.

Lessons

  1. ChartObjects and the Chart Inside ThemReading11 minFree
  2. Adding a Chart in CodeReading7 min Pro
  3. Feeding the Chart with SetSourceDataReading8 min Pro
  4. Choosing the Chart TypeReading7 min Pro
  5. Titles, Axes and the LegendReading8 min Pro
  6. Working with Series and FormattingReading8 min Pro
  7. Exporting a Chart as an ImageReading7 min Pro