Dynamic Bubble Graph - with VB

NWalters

New Member
Joined
Jan 24, 2005
Messages
5
I have what should be a simple problem that I've been banging my head against for too long now. Cany anyone help?

I have a largish excel document with several worksheets. One of the worksheets is a bubble graph, which references a data table on another worksheet. I want to write a macro which will update the graph automatically whenever a new entry is added to the data table.

The problem is that the data table isn't static - other macors on the sheet add rows above it, so the cell references change over time. And I can't get the code right to get the bubble graph to add a new data point, looking at the data in the bottom line of the table.

Any ideas much appreciated.
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Forum statistics

Threads
1,147,844
Messages
5,743,512
Members
423,800
Latest member
IuneKeiki

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top