Macro Create Bubble Graph


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



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

%d bloggers like this: