Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change gradient color in chart for Excel 2007 | Charts and Charting in Excel | |||
How do I select two colors for Gradient Fill Excel 2007 | Charts and Charting in Excel | |||
Change pattern for individual data points on chart | Excel Programming | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
Can I change the colors in the fill color chart? | Excel Discussion (Misc queries) |