Need to move chart labels relative to stacked column height

**NBinIL** · 04-01-2009, 03:21 PM

I have charts that i update via data that changes often. I have labels for the value of the column (sometimes stacked) that are displayed.

My problem is that I need the labels to stay consistent with the top of the column. I can adjust the top of the label via VB, but I can't figure out where to adjust it to.

Ideally, I'd like to know the position of the top of the column w/in the chart, so i can move the label to the exact same relative position every time the data refreshes

Thanks in advance

**shg** · 04-01-2009, 03:47 PM

Please take a few minutes to read the forum rules about thread titles (and in general) and then amend yours accordingly.

**Doctorul** · 05-14-2009, 04:08 AM

Same problem here.
I need to find a way to link a label (from a dummy series) to a point value on a graph and set a relative distance from the point to the label using VBA code.
From what I understand, Excel 2007 has a built-in Label offset configuration option, but Excel 2003 has not, so I have to do this using code.

**Andy Pope** · 05-14-2009, 05:27 AM

Doctorul,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Labelling the top of the stack can be done with dummy series
http://www.andypope.info/charts/StackColTotal.htm