Recover Lost Data with MicroSD Card Recovery : How to Fix Error - Creating a Macro in Excel 2010 for Bubble Chart Data Labels?

Friday, September 23, 2016

Creating a Macro in Excel 2010 for Bubble Chart Data Labels

I have created a bubble chart in Excel, and I am trying to include data labels for each bubble with the following details:

The labels should be to the right of the bubble
The labels should show the series name and the bubble size

I've created the following macro, but unfortunately it works for only one specific bubble on one specific chart:

Sub BubbleChartLabels()
'
' BubbleChartLabels Macro
'
' Keyboard Shortcut: Ctrl+Shift+L
'
ActiveSheet.ChartObjects("Chart 7").Activate
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection(15).Select
ActiveChart.SeriesCollection(15).ApplyDataLabels
ActiveChart.SeriesCollection(15).DataLabels.Select
Selection.ShowSeriesName = True
Selection.ShowValue = False
Selection.ShowBubbleSize = True
End Sub

How do I make this work for all bubbles on all charts? (I have 7 charts per page)

PLEASE HELP

Keys to the Problem Creating a Macro in Excel 2010 for Bubble Chart Data Labels

Download SmartPCFixer to Fix It (Free)

Check memory problems

Memory management issues can also cause a BSOD in Windows 7. Thankfully, Windows 7 has a Memory Management Diagnostic tool that detects and solves problems related to system memory.

Click on the Start button on the Taskbar.
Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
Click on Windows Memory Diagnostic Tool (in the search results).
Click on "Restart now and check for problems (Recommended)".
The system will restart, and you need to follow the instructions given on the screen.

Another Safe way to Repair the Problem: Creating a Macro in Excel 2010 for Bubble Chart Data Labels:

How to Fix Creating a Macro in Excel 2010 for Bubble Chart Data Labels with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will perform a scan for your computer. The errors will be shown in the list.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.