Data labels for stack column chart

[thomas819]

Hello all,
I have run into my limit with VBA.

I am trying to set data labels using VBA in maner which you can see in attachement. Input data are changing every day, therefore I am looking for VBA solution.

Data labels (label1 - label8) displayed as numbers have to be allighed to TOP RIGHT corner and right side of it corrensponding data frame. In case is value is lowe then 3, I would to display this value outside of stack column chart.

Same logic should be apply to data labels (process1 - process8) displayed as text. It should be allighed with TOP LEFT corner and left side of it corrensponding data frame.

If you are willing share your expertise with me, I will be very gratefull.

Input data as you can see it inside the chart are bellow:

series	stage 1	stage 2	stage 3	stage 4	stage 5
Process1	63​	19​	10​	26​	37​
Process2	27​	29​	11​	24​	64​
Process3	13​	40​	39​	12​	10​
Process4	1​	24​	11​	29​	1​
Process5	5​	1​	9​	23​	5​
Process6	1​	#######​	34​	2​	1​
Process7	#########​	#######​	#######​	1​	#######​
Process8	#########​	#######​	#######​	#######​	#######​
OFF	8​	4​	3​	#######​	1​

Process1	Part1	Part1	Part1	Part1	Part1
Process2	Part2	Part2	Part2	Part2	Part2
Process3	Part3	Part3	Part3	Part3	Part3
Process4	Part4	Part4	Part4	Part4	Part4
Process5	Part5	Part5	Part5	Part5	Part5
Process6	Part6	0​	Part6	Part6	Part6
Process7	Part7	0​	0​	Part7	0​
Process8	0​	0​	0​	0​	0​
OFFlabel	OFF	OFF	OFF	0​	OFF

Legend:
######### = na()

 

[thomas819]

Thank you all for forcing me to reInvent my old approach.

I did it.

Trick was not to in determinate top left edge of each data sector inside stack column, but to create scatter plot.

Solution is working as it should