pie-chart problem using macro..

  • Thread starter Thread starter ashishprem
  • Start date Start date
A

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Can a pie of pie chart use animation/transitions? 1
Extract RGB values for selected chart series 2
Pie Chart Tweaking? 1
Making two pie charts look alike 4
Delete any Lables with "0%" value in pie chart 2
Colors on a pie chart 2
How to create multiple bar charts at the same time? 0
Pie Chart 6

Back
Top