pie-chart problem using macro..

[ashishprem]

Hi Guys,
I wrote one macro to create a pie-chart. Now the problem is whnever 1 run that macro a new pie chart is created. i want the same chart to be modified or the existing chart to be deleted and to create a new one. But don't know how to search an existing chart and modify or delete it.
Please help me.
Regards,
Ashish

[Peter Rooney]

Hi, AshishPrem,

Why are you running the macro again, once you've created the Pie chart?
If it takes its data from a certain area of the worksheet, if you update the
data, the Pie chart should update itself, too!

Cheers

Pete

"ashishprem" wrote:

>
> Hi Guys,
> I wrote one macro to create a pie-chart. Now the problem is whnever 1
> run that macro a new pie chart is created. i want the same chart to be
> modified or the existing chart to be deleted and to create a new one.
> But don't know how to search an existing chart and modify or delete
> it.
> Please help me.
> Regards,
> Ashish
>
>
> --
> ashishprem
> ------------------------------------------------------------------------
> ashishprem's Profile: http://www.excelforum.com/member.php...o&userid=31485
> View this thread: http://www.excelforum.com/showthread...hreadid=515200
>
>