Dynamic Chart in excel 2007 with 2 parameters

[Rayomand]

Hi,

I have been trying to get a Dynamic Chart with 2 parameters i.e. targets & actual. I can do it with one targets or actual. Can someone help me please.

I have attached a small example of what I want.

START DATE May-13
LENGTH 3

DATE TARGET ACTUAL
Apr-13 2 1
May-13 3 1
Jun-13 4 2
Jul-13 5 3
Aug-13 6 4
Sep-13 7 3
Oct-13 8 5
Nov-13 9 6
Dec-13 10 7
Jan-14 11 9
Feb-14 12 10
Mar-14 13 11

Thanks in advance.

Rayo

 

[GFC]

Excel 2007 ...
You may want to have a look at
http://office.microsoft.com/en-us/e...eate-dynamic-charts-in-excel-HA001109801.aspx

 

[Hui]

Have a look at the attached file
It uses 3 Named Formula, Date, Target, Actual

 

[Rayomand]

Have a look at the attached file
It uses 3 Named Formula, Date, Target, Actual

Thanks Hui, you have made it so simple. My problem is solved.

Regards,
Rayo

 

[Rayomand]

Excel 2007 ...
You may want to have a look at
http://office.microsoft.com/en-us/e...eate-dynamic-charts-in-excel-HA001109801.aspx

Thanks.