...
The following are the Auto Reposition Settings down to achieve the graph above.
...
Attach Data Labels To top Y axis and Auto Position
On Labels tab, user can set Data Labels to be attached to a Horizontal Line (Y line), Vertical Line (X line) instead of default attachment to data point and auto reposition in the other direction to avoid overlapping. Leader Line can be set to Polyline type.
The following are the Attachment settings and Auto Reposition Settings to achieve the graph above.
- Attach: Y Line – So the Y position of the data label will be aligned to horizontal Y line. Y1 means bottom X, Y2 means Top Y, user can also use other Labtalk variables.
- Y Offset to -500.
- Position Below.
- Rotate: 270 so text read from top to bottom.
- Auto Reposition to Avoid Overlapping: X.
- Leader Line Connect: Polyline Vert.