Change Gradient Fill Colors of Bar Chart data points
Im trying to modify the gradient fill colors of single data points on a bar
charts (in Excel 2007). The bar chart already has gradient fills defined manually. I think I need to alter different child properties of .Interior, not the ..ColorIndex property that would apply to non-gradient fills. Ive waded through the object model and help file and tried all kind of syntaxes, but cant get at the gradient without raising an error such as Run-time error 1004: Application-defined or Object-defined error or Run-time error 438: Object doesnt support this property or method. Recording a macro of my setting this manually doesnt help me since Excel does not record any of these steps in VBA!! I have tried the following: ..Interior.Gradient.InteriorGradientStop(1).Gradie ntStopColorIndex= RGB(a,b,c) ..Interior.InteriorGradientStop(1).GradientStopCol orIndex= RGB(a,b,c) ..Interior.Gradient.Colorstops(1).ColorIndex = RGB(a,b,c) (all the above with ActiveChart.SeriesCollection(1).Points(1) either referenced or selected) ..Gradient.ColorStops.Clear raises an error as well! Im sure this is something simple, but I just cant get it! Any help much appreciated. Paul |
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 |
Change Gradient Fill Colors of Bar Chart data points
Excel 2007 Chart
Macro, fill color gradient. http://c0718892.cdn.cloudfiles.racks...05_21_10a.xlsm Pdf preview: http://www.mediafire.com/file/ewzzhy2yedd/05_21_10a.pdf |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com