I have created a custom fan chart with the following contents:
%INDI.NAME[1]%
%INDI.BIRT[1].DATE:YEAR%-%INDI.DEAT[1].DATE:YEAR%
This works well where I have both birth and death dates or birth or death dates for an individual. However, where I don't have a name for an ancestor, I end up with a hyphen displaying in the box. Is there any way to avoid this?
* Custom Fan Chart
- Jane
- Site Admin
- Posts: 8442
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Re: Custom Fan Chart
You could simply use
%INDI.NAME[1]%
=Lifedates()
or
%INDI.NAME[1]%
=TextIf(Exists(%INDI%),%INDI.BIRT[1].DATE:YEAR%-%INDI.DEAT[1].DATE:YEAR%,"")
%INDI.NAME[1]%
=Lifedates()
or
%INDI.NAME[1]%
=TextIf(Exists(%INDI%),%INDI.BIRT[1].DATE:YEAR%-%INDI.DEAT[1].DATE:YEAR%,"")
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
- Kathryn
- Gold
- Posts: 29
- Joined: 03 Oct 2006 12:43
- Family Historian: V6
- Location: Meldreth, Cambridgeshire
Re: Custom Fan Chart
Thank you Jane. The first example works perfectly.
- tatewise
- Megastar
- Posts: 27088
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Custom Fan Chart
Note that =LifeDates(,STD) should give Baptism/Christening and Burial/Cremation life dates if Birth or Death are missing.
A variant on that you could use:
%INDI.NAME[1]%
=LifeDates(,EXT)
which gives estimated life dates preceded with a tilda ~ where all the standard dates are missing.
A variant on that you could use:
%INDI.NAME[1]%
=LifeDates(,EXT)
which gives estimated life dates preceded with a tilda ~ where all the standard dates are missing.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry