Supposing you have created a **chart** to track the daily sales based on a range of data in your workbook.

But you need to change or edit the number of the data every day, in this case, you have to update the **chart** manually so it includes the new data.

Note: In step 10, I insert a column to center the dashboard components.

Doing so changes many of the referenced cells and ranges throughout the first nine steps.

If you're working with the downloadable demo, don't let those differences confuse you — they'll all be off by one column.

The data in the sheet named Scrolling **Chart** has a record for each month, beginning with January 31, 2010, and ending with September 30, 2012.

In *Excel* 2007, 2010 or 2013, you can create a table to expand the data range, and the *chart* will update automatically. Select the data range and click Table under Insert tab, see screenshot: 2.

When this happens, **Excel** tries to accommodate by shaving off a few values.Assuming the date is selected in cell A1, =DATE(2010, MATCH($A

When this happens, **Excel** tries to accommodate by shaving off a few values.

Assuming the date is selected in cell A1, =DATE(2010, MATCH($A$1,lst Months,0) COLUMNS($A$2: A2),1) in-case you got some other types of values instead of months: To make it a bit simple, I will use a helper cell where we can identify the position of selected month in the list of months, like this: I have assumed that Jan is 0, Feb is 1 … To get this type of output we must use an **excel** formula called as MOD.

MOD formula takes 2 numbers tells us the remainder when first number is divided by second number.

When this is the case, you can add a scroll bar that lets the user scroll through the data.

While I've seen some complex techniques for employing this solution, my technique requires just 10 quick and easy steps.

||When this happens, **Excel** tries to accommodate by shaving off a few values.Assuming the date is selected in cell A1, =DATE(2010, MATCH($A$1,lst Months,0) COLUMNS($A$2: A2),1) in-case you got some other types of values instead of months: To make it a bit simple, I will use a helper cell where we can identify the position of selected month in the list of months, like this: I have assumed that Jan is 0, Feb is 1 … To get this type of output we must use an **excel** formula called as MOD. MOD formula takes 2 numbers tells us the remainder when first number is divided by second number. When this is the case, you can add a scroll bar that lets the user scroll through the data.While I've seen some complex techniques for employing this solution, my technique requires just 10 quick and easy steps.

**excel**formula called as MOD. MOD formula takes 2 numbers tells us the remainder when first number is divided by second number. When this is the case, you can add a scroll bar that lets the user scroll through the data.While I've seen some complex techniques for employing this solution, my technique requires just 10 quick and easy steps.

When this happens, **Excel** tries to accommodate by shaving off a few values.

Assuming the date is selected in cell A1, =DATE(2010, MATCH($A

When this happens, **Excel** tries to accommodate by shaving off a few values.

Assuming the date is selected in cell A1, =DATE(2010, MATCH($A$1,lst Months,0) COLUMNS($A$2: A2),1) in-case you got some other types of values instead of months: To make it a bit simple, I will use a helper cell where we can identify the position of selected month in the list of months, like this: I have assumed that Jan is 0, Feb is 1 … To get this type of output we must use an **excel** formula called as MOD.

MOD formula takes 2 numbers tells us the remainder when first number is divided by second number.

When this is the case, you can add a scroll bar that lets the user scroll through the data.

While I've seen some complex techniques for employing this solution, my technique requires just 10 quick and easy steps.

Are there any quick tricks to help you auto update a *chart* when you add new data to an existing *chart* range in *Excel*?

When this happens, **Excel** tries to accommodate by shaving off a few values.Assuming the date is selected in cell A1, =DATE(2010, MATCH($A$1,lst Months,0) COLUMNS($A$2: A2),1) in-case you got some other types of values instead of months: To make it a bit simple, I will use a helper cell where we can identify the position of selected month in the list of months, like this: I have assumed that Jan is 0, Feb is 1 … To get this type of output we must use an **excel** formula called as MOD. MOD formula takes 2 numbers tells us the remainder when first number is divided by second number. When this is the case, you can add a scroll bar that lets the user scroll through the data.While I've seen some complex techniques for employing this solution, my technique requires just 10 quick and easy steps.Are there any quick tricks to help you auto update a *chart* when you add new data to an existing *chart* range in *Excel*?

**excel**formula called as MOD.

MOD formula takes 2 numbers tells us the remainder when first number is divided by second number.

When this is the case, you can add a scroll bar that lets the user scroll through the data.

While I've seen some complex techniques for employing this solution, my technique requires just 10 quick and easy steps.

Are there any quick tricks to help you auto update a *chart* when you add new data to an existing *chart* range in *Excel*?