pbornemeier
Well-known Member
- Joined
- May 24, 2005
- Messages
- 3,915
I have some code that adds a text box to a column chart at a fixed location from the top and left of the chart. Currently, if the text box covers the top end of any column, I manually reposition it so that is either in an area at the top of the chart where no bars extend, or to the lower half of the chart where all of the bars would go past the top of the text box.
Is there any way to detect whether a text box (or any shape for that matter) overlaps one or more chart elements (i.e. column, legend, title) or for that matter another shape or text box?
Is there a way to determine the location of a "clear area" (of specified size) where a text box could be placed?
I'm sure there could be some cases where the end of a bar must be covered, but if that happens, I will have to live with it.
Is there any way to detect whether a text box (or any shape for that matter) overlaps one or more chart elements (i.e. column, legend, title) or for that matter another shape or text box?
Is there a way to determine the location of a "clear area" (of specified size) where a text box could be placed?
I'm sure there could be some cases where the end of a bar must be covered, but if that happens, I will have to live with it.