Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help setting Series Interior.Color to Custom color!

Status
Not open for further replies.

questiongirl

Programmer
Feb 7, 2006
2
US
I need to set custom colors on Data Series in the charts I create in Power Point VBA. When I try to set it to the custom RGB color RGB(64, 179, 179), it doesn't get the right color, it gets 13421619 rather than 11776832!!! This is happening with a series of custom colors I want to set! A sample of my code follows:

Dim sers as Object
For Each sers In newGraph.SeriesCollection
'Set the colors of the chart
sers.Interior.Color = RGB(64, 179, 179)
Next

I've read that MSGraph must be choosing the closest standard color, but I haven't read how to fix this! Please help! I have been stuck on this one for days and I have a deadline to meet SOON!! :(
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top