This page has 1 thread | Add post

Finding our videos useful? Please consider helping us to share more!

Training videos for learning EXCEL VBA - CHARTS

We have 6 Excel VBA - charts videos listed below.

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

You might also like to consider booking a place on one of our online or classroom VBA courses, where you could meet the owls behind the videos!

This page has 1 thread

Add a new post

From:	duggie
When:	01 Oct 23 at 19:06

I am trying to add 3D effect to my pie chart.

I manually created a pie chart, named it Chart 1, then applied the following 3D formatting:

Right-clicked on the chart to bring up the Format Chart Area on the right.

Under Chart Options, I selected the middle icon (Effects) then expanded 3D Format.

Under Top bevel, I chose Round (the first one). Similarly for Bottom bevel.

Recording the above actions genenerated this code:

With ActiveSheet.Shapes("Chart 1").ThreeD
.BevelTopType = msoBevelRelaxedInset
.BevelTopInset = 6
.BevelTopDepth = 6
End With
With ActiveSheet.Shapes("Chart 1").ThreeD
.BevelBottomType = msoBevelRelaxedInset
.BevelBottomInset = 6
.BevelBottomDepth = 6
End With

If I reversed my formatting actions, then run the code, nothing happens to the pie chart.

Furthermore, if I execute this in the Immediate Window:

ActiveSheet.Shapes("Chart 1").ThreeD.BevelTopInset = 6

followed by:

?ActiveSheet.Shapes("Chart 1").ThreeD.BevelTopInset = 6

it returns False!

Two questions spring to mind:

1. Is this yet another VBA quirk?

2. How can I use cod to set the bevel?

Thanks

From:	Andrew G
When:	02 Oct 23 at 08:38

Good question, sadly the short answer is: I don't know!

If it's any consolation I see the same behaviour - no 3D effects seem to affect a chart even if they work for a regular shape.

Sorry, I'm not sure what to suggest!

From:	duggie
When:	02 Oct 23 at 11:54

Thanks for the confirmation.

At least I know I'm not losing my marbles!

Add a new post

VIDEOS BY CATEGORY

VBA CATEGORIES

EXCEL VBA - CHARTS VIDEOS

VIDEOS BY AUTHOR

Training videos for learning EXCEL VBA - CHARTS

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

Head office

London

Manchester