I need help with a code to change the scale of a bar chart.

[delvi]

Hi People:hi:,

I need help with a code to change the scale of a bar chart.

I have a source data for a bar chart in the form of a table. The maximum and min value in the table has to be the max and min value in the scale of the bar chart. I need to select the max and min value from the table and input it in to the scale.
Since I have to do this to a lot number of charts, it takes a lot of time.

Please help me : pray2: with a code by which I can change the scale with the help of a macro.

[Bob Phillips]

Do the actions with the macro recorder on. This will get you started.

[delvi]

Thnx so much... I had already figured that out and it works.. I had to make some minor changes in the recorded one..

Thnx once again