Chart Update

[Box666]

I have a chart based on a worsheet that contains data on a monthly
basis for the last 2 years.

I only want the chart to show data for the last 13 months, I want it
to automatically update each month after i have added another row
(month) of data to the worksheet.

is this possible.

Bob

 

[Damon Longworth]

Set up a table using the offset function to retrieve the last 13 rows from
your data table. Use this new 13 range table as the source for the chart.
Copy a formula similar to this down 13 rows:

=OFFSET($A$1,COUNTA(A:A)-ROW(A1)+1,0)

--

Damon Longworth

2007 East Coast Excel / Access User Conference
April 18-20, 2007 - Providing Microsoft Excel training and Microsoft Excel
Classes
Atlantic City, New Jersey
www.ExcelUserConference.com/ECEUC.html

I have a chart based on a worsheet that contains data on a monthly
basis for the last 2 years.

I only want the chart to show data for the last 13 months, I want it
to automatically update each month after i have added another row
(month) of data to the worksheet.

is this possible.

Bob

 

[Jon Peltier]

An alternative approach:

http://peltiertech.com/Excel/Charts/DynamicLast12.html

- Jon