Programming Modern Chart Types

This is the first in a series of videos to accompany my web article: Modern Charts Improvements: Part 3 - Use VBA Code to set Chart Properties: https://www.isladogs.co.uk/modern-charts-code/ VBA support was added to modern charts with the Beta version 2502 build 18514.20000 released on 17 Jan 2025. It will be rolled out to the Current Channel in early March The new functionality means you can now modify the appearance of modern charts at runtime. For example, features such as gridline type / colors and sort order. This video shows how you can alter the chart type using a combo box or loop through all chart types in turn on a button click TIMES 0:00 Introduction - use VBA to modify chart properties at runtime 0:16 Until now chart properties could only be altered in design view using the property sheet and chart setting task pane 1:45 Demo - change chart type using combo box 3:15 Loop through all 25 chart types on a button click 4:35 Save to keep modifications for future use 4:53 Thanks for watching