Auto updates

Topic

New Reply

Are you adding new data to a range of cells and then wish to automatically update the chart?

Reply | Quote

Replies

> I can of course updated by double clicking on the range and then dragging it to include the new data,<

It seems to me that you can do this with a VBA macro.

1. Identify the new data range, first cell/last cell
2. Assign the range (as a string value) to the chart property that needs it.
3. Initiate the action with a button on the sheet(s)

What do you think?

Reply | Quote

Set your chart series to extend 1 row beyond the last row of data. As long as the new data row is inserted and not pasted on top of that blank row, your chart series will automatically expand to include the inserted row.

You’ll have to tolerate one empty column at the right of your charts, which shouldn’t bother anyone. Or you can change all charts to line charts, and have some more options about shifting axes. This method doesn’t work well with area charts, which zoom down to zero on any blank point in their series.

Aloha,

JohnJ

Reply | Quote