Move data label relatively

**Serpiente** · 02-17-2012, 10:07 AM

Hi all,

I am doing a stacked bar chart and i want to place data labels in a position relatively to the size of the bar is reffering.

i am trying to do something like this:

Please Login or Register  to view this content.

This code will be inside a loop.

Thanks!!

**Andy Pope** · 02-17-2012, 10:13 AM

The points in a series do not have left/top properties.

Can you not use one of the built in data label positions?

Would it make it clear to us if you posted a workbook example with a data label manually positioned where you want it and the explanation of why that position.

**xlrotor** · 02-18-2012, 09:38 PM

Here's a snippet from a macro that works on xy scatter charts. I don't know what it will do with bar charts, though.
With .Points(j)
.ApplyDataLabels Type:=xlShowValue, LegendKey:=False
With .DataLabel
.Characters.Text = "sometext"
If XL2007 Then .Select
.Left = .Left - 5
.Top = .Top - 6
End With '\datalabels
End With '\.points

Brian in Austin, Texas

**Serpiente** · 02-19-2012, 01:24 PM

Hi all,

the problem is that i am trying to improve with macros a waterfall chart, and i need that datalabels look something like this:

positivos.PNG

and in case that values are negative, this will be the final look.

negativos.PNG

My first idea was to get the distance from the top of the bar to the top of chartarea and then calculate the new position of datalabels, but that obviously did not work.

At this point i am blocked with this, but i think that it does not have to be so difficult.

Thank you guys.