Home |
Search |
Today's Posts |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove the border for all series for all charts
On Apr 9, 4:08 pm, Joel wrote:
I didn't notice your chart was on a worksheet and not in a worksheet Sub xyz() For Each Allcharts In Charts Charts(Allcharts.Name).Activate ActiveChart.SeriesCollection(8).Select With Selection.Border .Weight = xlThin .LineStyle = xlNone End With Selection.Shadow = False Selection.InvertIfNegative = False Selection.Interior.ColorIndex = xlAutomatic Next Allcharts End Sub " wrote: On Apr 9, 3:10 pm, Joel wrote: For Each AllCharts In Worksheets("Chart 10").Shapes Sub Macro1() ' ' Macro1 Macro ' Macro recorded 4/9/2007 by b0467256 ' ' For Each AllCharts In Worksheets("Chart 10").Shapes ActiveSheet.ChartObjects(AllCharts.name).Activate ActiveChart.SeriesCollection(8).Select With Selection.Border .Weight = xlThin .LineStyle = xlNone End With Selection.Shadow = False Selection.InvertIfNegative = False Selection.Interior.ColorIndex = xlAutomatic next AllCharts End Sub " wrote: 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- Hide quoted text - - Show quoted text - When I run it the editor highlights all charts and says expected sub, function, or property? need some help please. This is for all charts in my workbook and for all series. thanks.- Hide quoted text - - Show quoted text - Thanks, Is there a way to use all the selected series and not be limited to just the series 8. the code works well otherwise. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |