Modern Charts - Change Series Options using Code

This is the second 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. This video shows how you can alter various series options such as series display name, sort order, fill color, show/hide data labels, gridline type & color TIMES 0:00 Introduction - use VBA to modify chart series options at runtime 0:16 Until now chart properties could only be altered in design view using the property sheet and chart setting task pane 0:45 Demo - chart with 3 series 1:35 Change sort order: (none/ascending/descending) based on the final series. but affects all series 2:20 Change fill color / show data label - set for each series individually 3:05 Change gridline type / color - normally set based on final series. 4:45 Can use different Major / Minor gridline types / colors for 2 series 5:48 Loop through all 25 chart types on a button click 6:15 Will demonstrate features of other new chart types such as Pareto / box & whisker in future videos 6:43 Thanks for watching