LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Color vs Colorindex for series border

Running on Excel 2003, I am attempting to set the .border.color property for
an x-y scatter series object using a long value that was generated by the RGB
function. However, the colorindex property seems to override it. I can
successfully change the marker colors, but the .border.color value reverts
back to the one associated with the colorindex value. I don't want to change
the palette because I have several charts in the workbook, each of which has
its own color scheme based on the number of series in the chart. Anyone know
why I can't just set the color property to an arbitrary value?
 
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
tab.colorindex linked to cell color Mike Excel Worksheet Functions 2 April 12th 07 12:44 AM
Trying to change ColorIndex for series settings SiriS Charts and Charting in Excel 3 March 14th 06 01:54 PM
How to change the default Border, Font Color, and Cell Color Elijah Excel Discussion (Misc queries) 3 November 2nd 05 11:52 PM
Default Border, Font Color, and Cell Background Color Elijah Excel Discussion (Misc queries) 1 October 28th 05 04:10 PM
Dynamically changing Border-Color of all series() to "0" moondark Charts and Charting in Excel 2 September 20th 05 02:40 PM


All times are GMT +1. The time now is 04:47 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"