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.
