we have one Excel data file in which we have the personnel number, the startdate of employees and in another column the enddate of employees. we now use a calendar script to extract Year from both columns (i.e. startyear from the startdate field and endyear from the enddate field).
Now we try to create a bar chart with "Year" on the X-axes. problem is that we have to choose either the year from the startdate or from the enddate. is there a way to combine this and just show year with per year two lines (one for the number of employees that started and one for the number that has left).