LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default remove the border for all series for all charts

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i remove the border around a text box Mike M. Excel Discussion (Misc queries) 1 September 3rd 08 05:06 PM
Color vs Colorindex for series border HC Hamaker Charts and Charting in Excel 1 May 16th 07 02:37 AM
Charts switch from 'Series in Rows' to 'Series in Columns' Peace Charts and Charting in Excel 4 March 22nd 07 03:52 AM
Dynamically changing Border-Color of all series() to "0" moondark Charts and Charting in Excel 2 September 20th 05 02:40 PM
Remove border line of a few cells Raymond[_8_] Excel Programming 1 June 29th 04 06:13 PM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"