hi,

Thanks for the reply, I have try it but it didnt work for my case.

There are some typing errors in the original post:

I ve put all this in the perl program but it has no effect, the chart always diplay as bar charts, and I CANT use perl to delete and data set in it.

Also If I insert the data first and create chart, as I CANT remove the data set, it alwasy give me the wrong data set in chart.

So bassicaly I cant do anything with excel other than insert data and create chart.

Thanks