Macro Create Bubble Graph

0

Have many module support for Excel as create, write data, table and paint graph function. But these module don’t support for some graph as Bubble, Scatter..

This post, I will guide for you create Bubble graph by Macro code.
Macro use Visual Basic (VB) language,

Macro Create Bubble Graph

 

Step 1: create label with data for Bubble Graph

Macro Create Bubble Graph

 

Step 2: Paint the Bubble Graph by Macro code

In Objects/ThisWorkbook:

 

in Modules, create Module1 with the content:

 

Step 3: Save file and run script or reopen that file and see result

macro-create-bubble-graph-2

 

Hope userful for you.

 

About Author

Là một developer rất ham chơi nhưng không ham hố, không ham chơi nhưng rất thích cầm đầu...

Leave a Reply