Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a series of embed charts in a worksheet, all of which need to
have various changes made. I am currently using code as follows (extract) 'Sets the series point markers With Selection .MarkerBackgroundColorIndex = xlNone .MarkerForegroundColorIndex = 3 .MarkerStyle = xlPlus End With 'sets the depth axis properties ActiveChart.Axes(xlValue).Select With ActiveChart.Axes(xlValue) .MinimumScale = MinDepth .MaximumScale = MaxDepth .ReversePlotOrder = True .CrossesAt = MinDepth End With In varoious articles on this news group I have seen it mentioned that selecting an object slows the code down and isnt nesacarally the best option. I am curious as to what would be the best practice for this situation |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
Can you speed UP drag speed? | Excel Discussion (Misc queries) | |||
Speed? | Excel Programming |