Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Mac > Excel for Mac > Setting chart s...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 325 of 342
Post > Topic >>

Setting chart series color

by "brujolito@[EMAIL PROTECTED] " <brujolito@[EMAIL PROTECTED] > May 9, 2008 at 12:02 PM

I am running Excel 2004 for the Mac on OSX 10.5.2.

I would like to set the color of a chart series from RGB values stored
in cells of the worksheet.

I recorded a macro to get this piece of code:

ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveChart.ChartArea.Select
    ActiveChart.SeriesCollection(7).Select
    With Selection.Border
        .Color = RGB(0, 0, 0)
        .LineStyle = xlNone
        .Transparency = 0
    End With
    With Selection
        .MarkerBackgroundColor = RGB(252, 243, 5)
        .MarkerForegroundColor = RGB(252, 243, 5)
        .MarkerStyle = xlSquare
        .Smooth = False
        .MarkerSize = 5
        .Shadow = False
        .MarkerTransparency = 0
    End With

The given RGB values are from the color picker, I would read them in
from the worksheet.

The problem is that if I manually change the color, and then run the
macro the color remains the one that I manually chose not the one
prescribed in the macro. If I change the Markersize to something other
than 5, that change is made. What gives????
 




 2 Posts in Topic:
Setting chart series color
"brujolito@[EMAIL PR  2008-05-09 12:02:53 
Re: Setting chart series color
"brujolito@[EMAIL PR  2008-05-09 12:09:21 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Oct 6 11:18:29 CDT 2008.