Labels porsition stacked column chart

**Snoopy2003** · 02-13-2011, 11:30 AM

Hello,

I use office 2010 to create stack column chart using VBA.

My problem - when series value is low chart labels are not readable (very small or
one label hide other label).

Is there any way to display labels outside chart with leading line ?

How can I make is visible ?

Thank you for your help

**Andy Pope** · 02-14-2011, 06:05 AM

There is nothing automatic, like there is for the pie chart.

You could use additional xy-scatter series to plot points and draw leader lines. But the coding would be very complicated.

A possible approach would be to duplicate the data series and plot on the secondary axis. Then adjust the Overlap property to space the data labels out.

Decrease the Gap Width of the series on the primary axis and then clear the fill formatting of the additional data series.

**Snoopy2003** · 02-15-2011, 12:29 PM

Thank you for your help. It looks better using your way.

Thank you

**KOsmix** · 02-01-2013, 06:15 PM

I want to achieve the same thing because I have very small values and the labels are overlapping. Any new idea of how I can link a label with a line (see the example attached) or another way of displaying the labels to be readable?
Example.jpg

**arlu1201** · 02-02-2013, 02:30 AM

KOsmix,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

**KOsmix** · 02-02-2013, 05:09 AM

Originally Posted by arlu1201

KOsmix,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

Ok, I understand. I've started a new tread here:
http://www.excelforum.com/excel-prog...bar-chart.html
Thank you.