Excel VBA Charts ( also 3 Surprise Tests for you ) Series 11

How to create new charts in excel using any data. We can fully automate the making of charts using VBA.

Learn the Chart class called Chart and see how easy it is to create the new charts.

The role of macro recordings plays a very important role here as most of the code we can record and later customize as per  the requirement.

How to work with existing charts in excel. How to go to each of them one by one and do modifications. Any type of modification like changing chart design or editing labels or chart titles etc

Understand the Loops importance in charts. You can loop through infinite charts using one simple collection loop.

Collection loops of charts – to work with multiple charts either to delete them or to edit their design, colors. You can do whatever. Even change the axis’s.

Use of other Collection loops with chart collection loops. Loops in Loops.

Projects for you to know more about Charts using input–box and range commands– Great case studies. It is out and out practical cases.

3 Bonus videos for you– Surprise tests conducted in my online classes (Advance Level) – Arrays, Functions, File folder handling , if functions and Loops) Its  a mixture of all important VBA topics. These tests are going to benefit you if you already have a good knowledge of these topics)