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 FamilySearch video says to do. I'm stuck with "linking" my column A "event" to be "inserted" in my callout shape.
I am about to give in and purchase a ready-made Timeline that's available, but thought I'd ask first
Thank you, Liz
3 Replies
- Riny_van_EekelenPlatinum Contributor
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.
- lizH707Copper Contributorcan't figure out how to add data labels.
- Riny_van_EekelenPlatinum Contributor
lizH707 Perhaps the article in the attached link will help.