That post is available here.][This post is about dynamic named ranges in Excel 2007.
You can easily create a chart based on a range of data in a worksheet.
Normally, if you add additional data to your range, you will need to once again create the chart or at best change the range of cells on which the chart is based.
The closest I've got is something like the following: However, this requires applying that formula to every cell in the primary column of the overview sheet.
And even then the range of the table isn't extended down to include new rows as they become valid.
Nevertheless it is possible to transpose the data source (see Transposing linked data).
In addition to the data, some cells to the left and on top are reserved for category and series labels.
As the world's leading business productivity suite, Microsoft Office provides many useful features including the ability to automatically display data from an Excel spreadsheet in a table in Microsoft Word.
This saves manually updating the contents of both an Excel spreadsheet and a Word document separately.
If you get tired of modifying charts to refer to new data ranges, there are a couple of shortcuts you can try out.
The first shortcut works fine if you simply need to "fine tune" the range used in a chart.
Jackson maintains a travel blog and regularly writes for the travel market.