Chart Automatically update and extend

**surfengine** · 11-17-2006, 12:52 PM

So I have a chart that shows data since (let's say) Nov 2005.
Each month I will append data to the data table, and then I edit the chart source and drag each series to include the new data.

My question is how can this be done without me having to manually edit the chart each time?
Is there somekind of plotif or chartif statement?

I should also mention that each of the cells of the source data would contain a formula. That formula would calculate a value. The value in the cells I dont want to use yet would be ZERO.

Thanks

**Mark@Work** · 11-17-2006, 01:19 PM

Add a "dummy" set of data at the end of your table where every value is set by =NA() to give #N/A.
Include these dummy values in the range to be plotted.
The chart will not plot these values, but will recognize them as part of your range.

Next time you add some data, select the row (or column) with the #N/A entry,
right click and select insert to insert a blank row (or column) between the existing data and the dummy entry.
Fill the new cells as required.

The chart should recognise that the range has been extended and will automatically plot your new values.

Mark.

Chart Automatically update and extend

LinkBack

Thread Tools

Rate This Thread

Display

Chart Automatically update and extend

Try this

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions