Automatic location and order of DataLabels?
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 |
Automatic location and order of DataLabels?
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). -- Thanks, Shane Devenshire "tskogstrom" wrote: 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 |
All times are GMT +1. The time now is 06:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com