Dynamic Name Range Charts in Excel
Excel Tip #014 Dynamic Name Range Charts in Excel It would be nice if a chart that gets updated right before your eyes at each data entry. This can be done creating Dynamic Charts . 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. There are two ways to build dynamic charts in Excel - Table method and Formula method. Let us see how to work with both the methods. Consider the below example having the sales for 5 sales rep. Example - Dynamic Chart Table Method: The first step is to create the table. To do so, simply select the data range and do the following: Click the Insert tab . Click Table . Excel will display the selected range, which you can change. If the table does not have headers, be sure to un-check the " My table has headers " option. Click OK and Excel will format the data range as a table. Creating the data as Table ...