VIDEOS BY CATEGORY▼
VBA CATEGORIES▼
- Excel VBA - Basics (23)
- VBA User Forms (21)
- Excel VBA - pivot tables (8)
- Excel VBA - charts (6)
- VBA - advanced (13)
- VBA - working with files (10)
- VBA - linking applications (9)
- VBA - working with Outlook (13)
- Built-in VBA functions (9)
- VBA - working with data (54)
- VBA - scraping websites (17)
- VBA - working with shapes (3)
- VBA - classes and structures (6)
EXCEL VBA - CHARTS VIDEOS▼
- Excel VBA Part 50.1 - Introduction to Charts in VBA
- Excel VBA Part 50.2 - Embedding Charts in Worksheets
- Excel VBA Part 50.3 - Conditional Formatting by Value in Charts
- Excel VBA Part 50.4 - Highlighting Min and Max Values in a Chart
- Excel VBA Part 50.5 - Formatting Bubble Charts by Bubble Size
- Excel VBA - Data Labels in Scatter Charts
VIDEOS BY AUTHOR▼
Training videos for learning EXCEL VBA - CHARTS
We have 6 Excel VBA - charts videos listed below. You might also like to consider booking a place on one of our online or classroom VBA courses, where you will meet the owls behind the videos!
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.