Auto Chart Problems

[Pearso]

I'm haveing problems creating a chart marker. I've done most of it see file at link below.

What i can do is edit the range of data by the date. It will make more sense when you look at the file. There are also comments in the file explaining what i want to do any help would be great. The comments are in the VBA code and on the worksheet. Also if the code in this file is helpful to anyone feel free to use it.

http://209.245.59.38/Gimme/15157901/...I_Web-Ver1.xls

[cssriraman]

http://209.245.59.38/Gimme/15157901...PI_Web-Ver1.xls

Unable to check your file. File downloaded with an error saying that "The file you are trying to access has not been made publicly available, and cannot be downloaded by anyone but the owner of the file."

Check it and upload the file to the forum or provide a valid link. So that we can check it.

[Pearso]

My file is too large try this link

http://home.ripway.com/2005-12/549402/KPIWeb-Ver1.xls

[Pearso]

Hey i Ziped the file and it works now see attached.