Automatic location and order of DataLabels?

  • Thread starter Thread starter tskogstrom
  • Start date Start date
T

tskogstrom

Hi,

I have a stacked column chart with three colors on all three columns,
created automatically with code. When the column is small, the labels
come upon each other - can anybody tell how code can ensure that
datalabels come above eachother and not upon each other?

Some code to ensure that they come x points over eachoteher (in right
order) if they are to close, maybe?

Kind regards,
tskogstrom
 
You are going to need to create formulas in the spreadsheet to control the
some hidden series. Create the formulas such that if the values are close
together the formulas add some additional value. Create two sets of these
formulas one to create values relative to the first series and the second for
values relative to the second series. For example =IF(A1-B1<5,B1+10,B1).
Plot these extra series on your chart with data labels but hide the markers
and line (or borders and area).
 
Back
Top