View Full Version : Solved: Updating Excel Chart

07-09-2008, 11:31 AM
I have an Excel Chart in one sheet, and the source data in another. The source data is arranged in two columns, which get updated every two weeks. There are zeros where the data ends.

I need to be able to set a starting point that can remain the same, but I need it to detect where the data ends and set the end of the souce data.

I'm not sure if that makes any sense.

07-10-2008, 01:41 PM
Maybe I should clarify a bit.

The collumns that are the chart's source data get longer, and when they do, I need the chart's source data to extend to include all that data, either automatically or with the press of a button.

Help would sure be nice. :helpThank you.

07-10-2008, 02:17 PM
incorporate SpecialCells(xlLastCell)