Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hello again, all you experts. I now have run into a new issue
when generating charts via VBA. I add data labels only if the datapoint belongs to a particular company. Sometimes, the data label is on the last (and highest) point on a distribution curve. It then runs into the title of the chart. I've been trying to capture this in code but am at a loss. I can't find any property of the data label that tells me its top. I haven't even gotten to trying to compare this with the bottom of the chart title! What I want to do is change the data label's position to bottom instead of top, if it overlaps the chart title. Does anyone have a nifty way to do this in VBA? Thanks in advance, Kate |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Possible to change chart title and label box widths? | Charts and Charting in Excel | |||
What does the '[Group]' label in the Excel title bar mean? | Excel Discussion (Misc queries) | |||
Possible to add second data label to pie chart? | Charts and Charting in Excel | |||
Resize chart data label | Charts and Charting in Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel |