I would like to have new rows created on the "Full Data" sheet automatically be added to the "Dynamic Chart" sheet, so that they may be automatically added to the graph.
I would like to have new rows created on the "Full Data" sheet automatically be added to the "Dynamic Chart" sheet, so that they may be automatically added to the graph.
If you put your data in an Excel Table and you build your chart off the table, then whenever you add data to the chart, the chart will pick it up automatically. Not only will it pick up new rows, but new columns will be added as a new series.
Here is some information on Excel Tables: http://www.utteraccess.com/wiki/Tables_in_Excel.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks