Excel VBA Introduction Part 50.6 - Data Labels in Scatter Charts

By Andrew Gould

[kasunmanchanayake]

best video series on Excel VBA I have ever found. If anyone want to learn Excel VBA this is the right place for you. Thank you sir. Keep up the good work.

[nunoponts]

really happy to see you back doing VBA videos. you awesome !

[bruce]

Andrew wonderful to see you back doing VBA videos. If you need any ideas I would love to see a series on Regular Expressions and/or Sorted Array Lists. I find the tutorials on the internet lacking as it seems you have to be a VBScript or .net expert to understand the advanced capabilities of using these in Excel.
Thanks for your consideration.

[krn]

Excellent narration. Happy Christmas!

[igort]

Pretty good but with the multiple labels in a single chart, those labels tend to overlap, making a chart rather useless. Can one prevent data labels from overlapping in VBA?

[Kavitachavan]

Hi,
Why we use VBA programming and macro development?
at the backend of MS Excel.
This is basic question for me.

[bengreen]

Hello Andrew, watched all your amazing videos from part one and this is my third attempt to watch them all! Going to make it this time. A quick (probably showing my ignorance) question, at 10.40, how does the r variable know what it is? Does the Dim r as range statement define it as a single cell by default?

[iamfriendly]

The problem with this is that I have 2000 data points and the data labels are absolutely useless unless I could hover over them. Is there a way to do this?

[meganyip]

Hi Andrew, I know this video is old, but is there a way to have one macro create the scatterplot, and then ask the user to select a point on the plot and label it based on this selection?