Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to create a gradient in my chart that goes from red to yellow.
If I just do a gradient fill it ends up looking more like orange to yellow unless I set the first stop position (red side) to around 20%. How can I do this via code? I can't find any method anywhere that might affect this. Below is how I create the gradient (using C#). // Get the series I want to fill with a gradient Excel.Series series = ((Excel.SeriesCollection)((Excel.ChartGroup)chart. ChartGroups(1)).SeriesCollection(Type.Missing)).It em(2); //Stop 1 : red stop position @ 20% // 2: yellow series.Fill.TwoColorGradient(Microsoft.Office.Core .MsoGradientStyle.msoGradientVertical, 1); series.Fill.ForeColor.SchemeColor = 3; // red--is there a better way to do this? series.Interior.PatternColor = 0x00ffff; // yellow |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Color gradient | Excel Programming | |||
Two-Color Gradient Fill? | Excel Programming | |||
How can I stop data labels reverting to a default position | Charts and Charting in Excel | |||
Position of CellCursor on Screen (absolute position) | Excel Programming | |||
Cell Gradient | Excel Discussion (Misc queries) |