link data label to callout in chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1711044%22%20slang%3D%22en-US%22%3Elink%20data%20label%20to%20callout%20in%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1711044%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20%26nbsp%3BI%20am%20using%20a%20X-Y%20scatter%20chart%20to%20make%20a%20historical%20chart%20(for%20genealogy).%20%26nbsp%3BI%20have%20the%20%22event%22%20(such%20as%20birth)%20%26nbsp%3Bin%20A%20column%2C%20the%20date%20in%20B%20(x%20axis)%2C%20and%20a%200%20(for%20y%20axis).%20%26nbsp%3BThis%20is%20what%20FamilySearch%20video%20says%20to%20do.%20%26nbsp%3BI'm%20stuck%20with%20%22linking%22%20my%20column%20A%20%22event%22%20to%20be%20%22inserted%22%20in%20my%20callout%20shape.%3C%2FP%3E%3CP%3EI%20am%20about%20to%20give%20in%20and%20purchase%20a%20ready-made%20Timeline%20that's%20available%2C%20but%20thought%20I'd%20ask%20first%3C%2FP%3E%3CP%3EThank%20you%2C%20%26nbsp%3BLiz%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1711044%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1711683%22%20slang%3D%22en-US%22%3ERe%3A%20link%20data%20label%20to%20callout%20in%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1711683%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F808277%22%20target%3D%22_blank%22%3E%40lizH707%3C%2FA%3E%26nbsp%3BPerhaps%20like%20in%20the%20attached%20workbook%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdd%20data%20labels%20and%20format%20them%20such%20that%20they%20pick%20up%20the%20%22values%20from%20cells%22%20in%20column%20A%20and%20to%20%22show%20leader%20lines%22.%20Set%20the%20label%20border%20to%20a%20solid%20line.%20Then%20you%20can%20drag%20your%20events%20%22boxes%22%20to%20your%20liking.%20The%20leader%20lines%20will%20automatically%20follow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715554%22%20slang%3D%22en-US%22%3ERe%3A%20link%20data%20label%20to%20callout%20in%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715554%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F808277%22%20target%3D%22_blank%22%3E%40lizH707%3C%2FA%3E%26nbsp%3BPerhaps%20the%20article%20in%20the%20attached%20link%20will%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-or-remove-data-labels-in-a-chart-884bf2f1-2e29-454e-8b42-f467c9f4eb2d%23ID0EAACAAA%3DWindows%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-or-remove-data-labels-in-a-chart-884bf2f1-2e29-454e-8b42-f467c9f4eb2d%23ID0EAACAAA%3DWindows%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted

@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.

Highlighted
can't figure out how to add data labels.
Highlighted