Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting the gradientstops of a point in a macro
Hello!
I want to format each point of a serie in a chart. Each point has 3 gradientstops: 0, 50 and 100%. there's no problem in setting them from the excel interface, but I need creating them by means of a macro. I tried something like: Activechart.seriescollection(1).fill.gradientstops .insert rgb(0,255,0), 0.50 to insert the middle gradientstop, but this does not work. Someone knows how can I solve this problem? Thanks a lot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Notice in Excel of a reached set point setting. | Excel Discussion (Misc queries) | |||
setting a formula = to no point in a graph | Excel Discussion (Misc queries) | |||
setting defaults for data point size, color, shadow, etc. | Charts and Charting in Excel | |||
setting a floating decimel point | New Users to Excel | |||
Sending email via macro- setting the importance setting. | Excel Programming |