How to Build Dynamic charts in excel
                     HOW TO BUILD DYNAMIC 
CHARTS IN EXCEL
INTRODUCTION:
 If you need to progress your standard 
spreadsheet abilities, making dynamic 
graphs is a decent spot to start that 
adventure. The key is to characterize the 
graph's source information as a unique 
range. Thusly, the graph will consequently 
reflect changes and increments to the source 
information. Luckily, the procedure is 
anything but difficult to execute in Excel 
2007 and 2010 in case you're willing to 
utilize the table component. If not, there's an 
increasingly mind boggling technique. 
THE TABLE METHOD
 Click the Insert tab.
 In the Tables group, click Table.
THE TABLE METHOD
 Excel will display the selected range, which 
you can change. If the table does not have 
headers, be sure to uncheck the My Table 
Has Headers option.
 Click OK and Excel will format the data range 
as a table.
THE TABLE METHOD
   Any chart you build on the table will be 
dynamic. 
   Steps:
 Select the table.
 Click the Insert tab.
THE TABLE METHOD
 In the Charts group, choose the first 2-D 
column chart in the Chart dropdown.
 Update the chart by adding values
THE DYNAMIC FORMULA METHOD
 Dynamic outlines are utilized in activities, where there 
is a requirement for a programmed update to choose 
a unique go by changing the information which thus 
refreshes the diagram or chart. So also, dynamic 
outlines in exceed expectations are refreshed or 
resized when the dynamic information run utilized as 
source information is changed or erased. 
 The two primary techniques used to set up a powerful 
diagram are as per the following: 
 By Using Excel Table 
 Utilizing Named Range
THE DYNAMIC FORMULA METHOD
 Steps:
 Click the Formulas tab.
 Click the Define Names option in the Defined 
Names group.
 Enter a name for the dynamic range, Month 
Labels.
THE DYNAMIC FORMULA METHOD
 Choose the current sheet. In this case, that's 
DynamicChart1. You can use the worksheet, 
if you like. In general, it's best to limit ranges 
to the sheet, unless you intend to utilize 
them at the workbook level.
 Enter the following formula: 
=OFFSET(DynamicChart1!
$A$2,0,0,COUNTA(DynamicChart1!$A:$A))
 Click OK.
THANK YOU