Tricky (?) data labels position problem

[mrcheeks]

I want the default position of the data labels of the first series in my BarStacked100 chart to be in the center, i.e.: "DataLabelCenter".

However, when the position of centered data labels is more to the left than it would be if I used "DataLabelInsideBase", then i would like like them to be inside base, i.e.: "DataLabelInsideBase".

The reason I would like this is that when the value of a point is small, e.g. 1 %, then the data label for that point is partly on the axis of the chart. I would like it not to be.

Is it possible to automatically determine if centered data labels is more to the left then data labels inside base?

 

[mrcheeks]

___________________^
Posting newb in action |

I forgot to mention that I'm looking for the VBA code to determine said problem (i.e. automatically determine if centered data labels is more to the left than data labels inside base).

Somthing along the lines of

For i = 1 to myChart.SeriesCollection(1).Points.Count
 If myChart.SeriesCollection(1).Point(i).DataLabels.Position = Center Then
  If myChart.SeriesCollection(1).Point(i).DataLabels.[something to determine how far left the data label is] = [Too far left] Then
   myChart.SeriesCollection(1).Point(i).DataLabels.Position = InsideBase
Next i

I would very much appreciate your help!

mrcheeks

 

[mrcheeks]

I'm bumping this as I desperately need help from the sharp minds on this forum. Anyone feeling like having a go at this?

mrcheeks