Training videos for learning EXCEL VBA - CHARTS

Excel VBA Part 50.1 - Introduction to Charts in VBA

Posted by Andrew Gould on 17 November 2016

This video helps you to get started with charts in Excel VBA. You'll learn how to create a new chart sheet and set the chart's data source using a variety of techniques, including how to dynamically set the data source based on conditions. You'll also see lots of ways to change the appearance of the chart, including using chart layouts, chart colour schemes, chart styles and even how to create your own custom chart template.

Excel VBA Part 50.2 - Embedding Charts in Worksheets

Posted by Andrew Gould on 21 November 2016

ChartObjects are charts that are embedded in a sheet in an Excel workbook. This video teaches you about the basic differences between charts and chartobjects, as well as how to change one type into another. You'll also learn a couple of neat tricks for positioning chartobjects on a sheet, including how to arrange multiple chartobjects so that they don't overlap.

Excel VBA Part 50.3 - Conditional Formatting by Value in Charts

Posted by Andrew Gould on 29 April 2019

Looping over the points of a chart and testing the value of each should be a simple task in Excel VBA but it's slightly trickier than you might expect! This video explains how to access the values array of a series, how to loop through it and use the values to apply a format to each point. As an added bonus, you'll learn how to loop through the collection of series so that you can test every single point in a chart.

Excel VBA Part 50.4 - Highlighting Min and Max Values in a Chart

Posted by Andrew Gould on 29 April 2019

In this video you'll learn how to highlight the minimum and maximum values in a chart using VBA. You'll learn how to loop over the series collection of a chart, capture the array of values associated with the series and calculate the minimum and maximum values using worksheet functions. You'll also learn how to loop over the array of values and apply formatting to the data points which match the maximum and minimum values. In the final part of the video you'll see how to apply the same techniques to a line chart, including how to display markers on the lines.

Excel VBA Part 50.5 - Formatting Bubble Charts by Bubble Size

Posted by Andrew Gould on 29 April 2019

In this video you'll learn how to test the size of each bubble in a bubble chart to apply conditional formatting. You see how to reference the BubbleSizes property and how to capture the range of cells containing these values in an array. You'll learn how to calculate the min and max sizes of the bubbles and how to loop through the array of sizes and test the value of each.

Excel VBA - Data Labels in Scatter Charts

Posted by Andrew Gould on 27 November 2015

Labelling data points in a scatter chart in Excel 2010 or earlier is much more limited than in later versions of Excel. This video explains how to use VBA to label the points with any value you like using simple looping techniques. You'll learn how to label the points in a single chart, multiple charts and multiple data series in a chart.