Rescale the Chart Dynamically - I have briefed my situation.

[Peri]

I will brief you my situation. Can you please help me out ?

I have an excel sheet with the graph placed on it. I am diplaying the graph
by filling up the values in the cell range say (AA1 to AB10) using the VB
Code. Now I want to rescale the chart dynamically and I will need to set the
name of the X axis, Y axis and the Chart Title.

Can you please help me to solve this ?

Thanks and Regards,

Peri