ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Remove shape at series point (2007) (https://www.excelbanter.com/excel-programming/420067-remove-shape-series-point-2007-a.html)

Herbert Seidenberg

Remove shape at series point (2007)
 
In Excel 2003 I was able to remove a shape on a chart with
Sheets("Chart3").SeriesCollection(1).Points(10).Cl earFormats
But Excel 2007 just reformats the point or line
and leaves the shape (an arrow) in place.
The arrow needs to morph at the head of a moving line.
Any workarounds?

Herbert Seidenberg

Remove shape at series point (2007)
 
Found it:
..Points(n).MarkerStyle = xlMarkerStyleNone


All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com