Dynamic Macro related query

[rahulsharma012]

I am attaching an excel as attachment.


https://hotfile.com/dl/184288083/44bd6ee/Book1122.xlsm.html


my question is that as you see in sheet1 there is a command button with name sales 2009 when you click on it a chart get displayed showing sales for 2009.But i am unable to generate chart for 2010 sales with the click of another command button with name sales 2010.

I want sales 2010 in the same chart as i click on sales 2010 command button.


plz send the file again as hotfile link.


regards,

Rahul sharma

 

[NARAYANK991]

Hi Rahul ,


I cannot upload the file to Hotfile ; can you download it from here ?


http://speedy.sh/cHKYJ/Book1122-R1.xlsm


If you cannot , I can upload it to Google Docs or 2shared.


Narayan