Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Attempting to remove the border for all series for all charts in my
spreadsheet. can this be modified? if so, pelase suggest how? thanks Sub Macro1() ' ' Macro1 Macro ' Macro recorded 4/9/2007 by b0467256 ' ' ActiveSheet.ChartObjects("Chart 10").Activate ActiveChart.SeriesCollection(8).Select With Selection.Border .Weight = xlThin .LineStyle = xlNone End With Selection.Shadow = False Selection.InvertIfNegative = False Selection.Interior.ColorIndex = xlAutomatic End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i remove the border around a text box | Excel Discussion (Misc queries) | |||
Color vs Colorindex for series border | Charts and Charting in Excel | |||
Charts switch from 'Series in Rows' to 'Series in Columns' | Charts and Charting in Excel | |||
Dynamically changing Border-Color of all series() to "0" | Charts and Charting in Excel | |||
Remove border line of a few cells | Excel Programming |