I have a plan map that I have added to a worksheet that I would like to add labels to. Each label would contain three lines of text from referenced cells; i.e. :
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Label1 Text 1
[/TD]
[TD]Label 1 Text 2[/TD]
[TD]Label 1 Text 3[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Label2 Text 1
[/TD]
[TD]Label 2 Text 2[/TD]
[TD]Label 2 Text 3[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Label3 Text 1
[/TD]
[TD]Label 3 Text 2[/TD]
[TD]Label 3 Text 3[/TD]
[/TR]
</tbody>[/TABLE]
The Label would look something like:
Text 1 Text 2 and would ideally have a callout leader.
Text 3
The labels would be created in an empty space and the user would drag them to the desired location on the plan map.
I have done this for adding labels to a chart but not sure how to do so when outside of a chart.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Label1 Text 1
[/TD]
[TD]Label 1 Text 2[/TD]
[TD]Label 1 Text 3[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Label2 Text 1
[/TD]
[TD]Label 2 Text 2[/TD]
[TD]Label 2 Text 3[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Label3 Text 1
[/TD]
[TD]Label 3 Text 2[/TD]
[TD]Label 3 Text 3[/TD]
[/TR]
</tbody>[/TABLE]
The Label would look something like:
Text 1 Text 2 and would ideally have a callout leader.
Text 3
The labels would be created in an empty space and the user would drag them to the desired location on the plan map.
I have done this for adding labels to a chart but not sure how to do so when outside of a chart.