Forum Discussion
link data label to callout in chart
Hello, I am using a X-Y scatter chart to make a historical chart (for genealogy). I have the "event" (such as birth) in A column, the date in B (x axis), and a 0 (for y axis). This is what Family...
lizH707 Perhaps like in the attached workbook?
Add data labels and format them such that they pick up the "values from cells" in column A and to "show leader lines". Set the label border to a solid line. Then you can drag your events "boxes" to your liking. The leader lines will automatically follow.
can't figure out how to add data labels.
lizH707 Perhaps the article in the attached link will help.