How do I make a line graph from this data?

[Sundlof]

Hi,
I want to create a line graph to map progress for a couple of people. On the X axis I want date, I have Min and Max but manually can do. On the Y axis I have 0 to 100%. The progress is entered in a three column table with Name, Date and progress. So Person 1 can have multiple entries with 2024-01-01 5%, 2024-01-15 16% and so on up to 100%.

I want to track each individual as their own line and also create a base line with a start and end date from 0 to 100% and compare if they are above or under the target progress.

How do I accomplish this?

 

[awoohaw]

Why do you need 3 Columns? Take your 3 column list and pivot it into a crosstab. I guess on what you want for a baseline.

 

[Sundlof]

Why do you need 3 Columns? I don't know what your baseline curve is to put those in.

View attachment 106900

Hi, and thanks for the reply.
The reason the data looks like this is that not all people gets an update the same day. I might be several days between, like the example below. The baseline is only a linear line going from a start date to an end date straight from 0 to 100%. So I thought this the data will be easier to update, I just add a new line when I get some update on someone progress.
I am all open for any other approach on this!

Name	Date	Progress
Person 1	2024-02-10	25%
Person 2	2024-02-12	60%
Person 3	2024-02-15	50%
Person 2	2024-02-03	40%
Person 3	2024-02-04	36%
Person 1	2024-01-29	15%

 

[awoohaw]

You can still create a crosstab using NA for missing value and the lines will continue, Here is a line chart with markers: