pie-chart problem using macro..
 

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

pie-chart problem using macro..
 

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