Creating a Dynamic Chart in Excel

Step 1

Enter a number in cell A1 and hit the enter key and then click on cell A1

Step 2

Click on the Formulas tab in Excel and then click in the “Name Manager” button. The following Window will appear

Step 3

In the Name Manager window, click the “New” button and in the Window that appears, type the name “ChartData” in the “Name” textbox and in the “Scope” list box, select “Sheet1” and then enter the following formula in the textbox labeled “Refers to”:

 =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A))

It should look similar to the following:

Click the OK button to return to the Name Manager window and then click the “Close” button in the Name Manager.

Step 4

Click on the “Insert” tab in the Excel main menu and then in the “Charts” section of the ribbon, click on the type of chart that you want. This will insert a chart in the worksheet.

Step 5

The Design tab should automatically be selected in the Excel main menu. If it is not, select it and then click on the button labeled “Select Data”. This will open a new window:

If you see a series named “Series 1” already in the window, click the button labeled “Remove” and then click the button labeled “Add” to add a new data series. The following window should appear:

Change the “Series name” entry to “Series 1” (or whatever name you want for the data series) and then enter the following for the “Series values” entry:

 =Sheet1!ChartData

Click the OK button in the “Edit Series” window and then click the OK button in the “Select Data Source” window.

As you enter numbers down column A, you should see your chart update automatically.

Contact Us