Thread: Change Gradient Fill Colors of Bar Chart data points
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
p45cal[_281_] p45cal[_281_] is offline
external usenet poster
  
Posts: 1
Default Change Gradient Fill Colors of Bar Chart data points

perhaps the likes of:


VBA Code:
--------------------


Sheets("Chart1").SeriesCollection(1).Points(4).For mat.Fill.ForeColor.RGB = RGB(112, 222, 123)
Sheets("Chart1").SeriesCollection(1).Points(4).For mat.Fill.BackColor.RGB = RGB(0, 0, 5)

--------------------


?


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=204339

http://www.thecodecage.com/forumz

Reply With QuoteReply With Quote