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.
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.