Self updating excel graphs
After you perform these steps, when you add data to columns B and C, the chart updates automatically to show the new data (see on the top of this screen).To use this technique for your own data, make sure that the first argument for the OFFSET function refers to the first data point, and that the argument for COUNTA refers to the entire column of data.The key is to define the chart's source data as a dynamic range.By doing so, the chart will automatically reflect changes and additions to the source data. First, we'll use the table feature, available in Excel 20-you'll be amazed at how simple it is. To do so, simply select the data range and do the following: Now, update the chart by adding values for March and watch the chart update automatically.It's important to remember that you enter new data in a contiguous manner.If you skip rows or columns, this technique won't work as expected. Because the chart defaults will use the label headings in each column for each series name, you can't use those labels to name the dynamic ranges.
You can always use Excel's sort feature to reorder the data in the table, all without affecting what is presented in the chart.
For additional information, see these Web resources: Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.
He is president of Sharon Parq Associates, a computer and publishing services company. Check out You need the added steps 5, 6, 7, at least in Word 97.1. OK Thank you for the tips, but when I try method one a message appears - "There's already data here. " I click OK, the data is MOVED from its row of cells on the spreadsheet, and the chart doesn't update.
Fortunately, the process is easy to implement in Excel 20 you're willing to use the table feature. You won't always want to turn your data range into a table.
Furthermore, this feature isn't available in pre-ribbon versions of Office.