Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a little routine that replaces the data points on an X-Y chart series
with arrows pointing in the direction of the line. That part works fine. The arrows are gradient filled block arrows, rotated to the proper angle for each data point. The arrows start out horizontal, with a horizontal one-color gradient fill. When I rotate the arrows, the gradient fill is not rotating with them - it stays horizontal. I recorded a macro to get the VBA code to set the gradient fill. I am trying to figure out what property I need to set to emulate the "Rotate fill effect with shape" check box option in the "Fill Effects.../Gradient" dialog box. When I record macros with and without that box checked, there is no difference in the code. Do any of you know what the VBA code is to set that option? TIA, Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I rotate objects in draw without changing shape? | New Users to Excel | |||
Where do I find buttons to change shape to 3-D and rotate in 2007 | Excel Discussion (Misc queries) | |||
How do I rotate a triangle diagram shape. | Excel Discussion (Misc queries) | |||
Rotate a Shape | Excel Programming | |||
R1C1 seems to effect listbox fill in VBA | Excel Programming |