I've created a cascading chart stacked in Google Sheets, with custom data tags (guided by Ben Collin's tutorial on custom data labels).
My goal is to place the custom data label at the center of each segment of the stack.
When using the Value label type, the labels are positioned correctly using Center (Example 1 below).
When I change the type of custom label, the positioning becomes non-centered (example 2 below).
I have tested the following behavior when using custom labels:
- The problem persists when selecting other types of items. The Center option is not unique
- The problem persists when all segment values are positive (see Example 3 below).
Is this a known problem with custom data labels? Are there any known fixes / workarounds?
Or should I use the addition of manually positioned text boxes on segments of the stack for custom, centered data labels?
Example 1 – Value tags & # 39; Are correctly positioned in the center
Example 2 – "Custom" labels are incorrectly positioned
Example 3 – The problem persists when all segment values are positive. The custom labels below are not centered.