| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Remove shape at series point (2007)
Found it:
..Points(n).MarkerStyle = xlMarkerStyleNone |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL2003: Shape-borders on scatter-series' look wavy | Charts and Charting in Excel | |||
| How do I drag a point to change the shape of a curve? (excel 2007) | Charts and Charting in Excel | |||
| How do I change the shape of a data series | Charts and Charting in Excel | |||
| in Excel 2007, how do you remove the decimal point in General | New Users to Excel | |||
| Deleting shape series and trendlines | Excel Programming | |||
Hybrid Mode
