JS,

I have created a solution for your request that I'll post to my site
sometime today Friday, May 13 or Saturday May 14. Please check the site
below this afternoon or tomorrow.

--
Regards,
John Mansfield
http://www.pdbook.com


"JS" wrote:

I have a chart that uses a combo box to choose the business unit and it give
the monthly activity for the last 12 months. I want to include another line
that will show the 12 month trailing average (Last 12 month average) for
whatever business unit is chosen. Can someone help me on this. The table
set up is as follows:

Business Unit Oct-04 Nov-04 Dec-04 etc....
Northern 200,000 150,000 75,000
Southern 100,000 50,000 125,000

Many thanks.