| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to remove a drawn chart object using VBA.
I have a school project that requires me to draw a polygon on a chart
(through VBA), then using a macro button, change the points of the polygon and re-draw it. I must eliminate the first polygon before, or immediately after drawing the second one. This way it will look like it's rotating around an axis. I have the points drawn, I have the polygon filled in with color. I can rotate the nodes if I use CNTL =. I need to be able to press a button, have CNTL plus = function properly, then remove the first polygon and draw the next one. Help anyone? -- Raas |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to remove a drawn chart object using VBA.
Hi,
Jon Peltier has a page detailing drawing polygons on charts which should prove useful reading. http://peltiertech.com/Excel/Charts/VBAdraw.html Cheers Andy Raas wrote: I have a school project that requires me to draw a polygon on a chart (through VBA), then using a macro button, change the points of the polygon and re-draw it. I must eliminate the first polygon before, or immediately after drawing the second one. This way it will look like it's rotating around an axis. I have the points drawn, I have the polygon filled in with color. I can rotate the nodes if I use CNTL =. I need to be able to press a button, have CNTL plus = function properly, then remove the first polygon and draw the next one. Help anyone? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to remove a drawn chart object using VBA.
Good try, but this link only showed how to draw the polygon, not delete and
redraw. I do appreciate the information for other purposes however. I did figure it out myself. Thanks -- Raas "Raas" wrote: I have a school project that requires me to draw a polygon on a chart (through VBA), then using a macro button, change the points of the polygon and re-draw it. I must eliminate the first polygon before, or immediately after drawing the second one. This way it will look like it's rotating around an axis. I have the points drawn, I have the polygon filled in with color. I can rotate the nodes if I use CNTL =. I need to be able to press a button, have CNTL plus = function properly, then remove the first polygon and draw the next one. Help anyone? -- Raas |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to remove a drawn chart object using VBA.
I assume then that you worked out you need something like.
Activechart.Shapes(1).Delete Raas wrote: Good try, but this link only showed how to draw the polygon, not delete and redraw. I do appreciate the information for other purposes however. I did figure it out myself. Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Positioning a drawn line shape on a chart | Charts and Charting in Excel | |||
| text boxes drawn objects do not appear on chart | Charts and Charting in Excel | |||
| Copy Excel Chart (including drawn objects) into Word | Charts and Charting in Excel | |||
| How do I measure area under a line chart drawn in Excel file? | Charts and Charting in Excel | |||
| Prevent User from Deleting Drawn Object | Excel Programming | |||
Linear Mode
