Sep 24 2020 04:21 PM
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
Sep 24 2020 10:23 PM
@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.
Sep 25 2020 01:36 PM
Sep 25 2020 08:59 PM
@lizH707 Perhaps the article in the attached link will help.