Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart/Shape Objects: De-Link From Column Widths?
When I create Chart objects from VBA, I'm using (X,Y) coordinates to place them.
But after they're all created/placed and the dust has settled, if the user re-sizes a column any charts that are laying over that column get their widths changed by the amount of the column width change. Ditto row height changes. Is there any way for me to de-link the Chart objects from the row and column dimensions - so that they just float there and are unaffected by changes to same? -- PeteCresswell |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart/Shape Objects: De-Link From Column Widths?
Per (PeteCresswell):
Is there any way for me to de-link the Chart objects from the row and column dimensions - so that they just float there and are unaffected by changes to same? Oops! Got it: .Placement = xlFreeFloating -- PeteCresswell |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart/Shape Objects: De-Link From Column Widths?
Oops!
Ha ha, the Send button works miracles, eh? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "(PeteCresswell)" wrote in message ... Per (PeteCresswell): Is there any way for me to de-link the Chart objects from the row and column dimensions - so that they just float there and are unaffected by changes to same? Oops! Got it: .Placement = xlFreeFloating -- PeteCresswell |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart/Shape Objects: De-Link From Column Widths?
Per Jon Peltier:
Oops! Ha ha, the Send button works miracles, eh? Once I worked with a lady that maintained that every keyboard should have an "Oh ****!" key. You press it and it automagically recalls the last thing your sent out. -- PeteCresswell |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart/Shape Objects: De-Link From Column Widths?
(PeteCresswell) wrote:
Per Jon Peltier: Oops! Ha ha, the Send button works miracles, eh? Once I worked with a lady that maintained that every keyboard should have an "Oh ****!" key. You press it and it automagically recalls the last thing your sent out. Obviously she went on to help design Microsoft Exchange. Those of us who use *real* email get to laugh twice when that happens. Bob -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different widths for each column in a 100% stacked column chart | Charts and Charting in Excel | |||
Column chart with different column widths | Charts and Charting in Excel | |||
How can I rotate objects in draw without changing shape? | New Users to Excel | |||
Conditional Formatting for a Column Chart and Auto Shape | Excel Discussion (Misc queries) | |||
Select Multiple Shape Objects | Excel Programming |