I would show information like this similar to a MS Project Gantt chart with horizontal bars rather than vertical (the flow of time is best shown horizontally)
So I would:
1. Change to a Stacked Bar
2. Change the DDate column to 'Age at Death' and change the value in those cells to calculate eg =1945-1877
3. Change the colour of the Bdate bar to 'No fill' (effectively hiding it)
4. Change the axis starting point to a whole number close to the first date eg 1850.
EDITED: I see you got the same advice on the other site
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Last edited by Guessed; 04-02-2024 at 10:08 PM.
Reason: Checked cross-posted site
|