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.

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.

The explanation is added now. Here is the link.

http://www.pdbook.com/index.php/exce...verage_series/

Hope it helps.

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


"John Mansfield" wrote:

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.

John,
I'm following your suggestions. I'm actually trying to first recreate what
you have done and then adjust to my data. Here's where I get stuck... When I
am in the Source Data box under the Series tab and type in the Name to be
=Test.xls!VRange I get the following message...

Your formula contains an invalid external reference to a worksheet. Verify
that the path, workbook, and range name or cell reference are correct and try
again.

I have name my file test.xls. Please advise.
I appreciate your time and assistance.
JS
"John Mansfield" wrote:

The explanation is added now. Here is the link.

http://www.pdbook.com/index.php/exce...verage_series/

Hope it helps.

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


"John Mansfield" wrote:

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.