Are you using a scatter chart or a line chart? It sounds like you are using a line chart, and what you want is a scatter chart with lines.

/u/Kiromana - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

You use scatter plot.

Like this?

/u/ThisIs4Work7616 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

You have to have a table that has the dates with the count of names with that date. You can make one manually with the countif function or a pivot table.

Excel is super easy. I figured out how to do it with google.

use excel

Do you not have excel?

Excel, Matlab, word. Lots of options.

Excel or R if we’re talking discrete experimental data.

Mathematica I love for plotting real functions.

For example, i will use the points p1 p2 p3 p4

So here, you take ruler and then connect p1 with p2 then remove your ruler and go to p2 and connect p2 with p3 then remove your ruler and go to p3 then take p3 with p4. Dont just draw one line through all of them you have to take each two points together until you’ve done all the points

If you dont understand you can check out a youtube video

You're supposed to join it with a ruler

Thanks for posting on r/IGCSE!
Please ensure that your post follows our community rules.

Important Rules:

• No Cheating: We do not support cheating. Requests for leaks, answers, or trying to access papers before they have been sat are strictly prohibited. More details: https://www.reddit.com/r/igcse/wiki/rules
• No Locked Paper Requests: Requesting or sharing locked exam papers (e.g., Feb/March 2025 papers before the official release) is considered piracy. These papers are only publicly available after the official results date. Violations may lead to warnings or bans.
• No Unapproved Advertisements: Do not promote external projects or services without prior moderator approval. More details: https://www.reddit.com/r/igcse/wiki/rules

Violating any of these guidelines may lead to a temporary or permanent ban.

Join our Discord server for study discussions and support: https://discord.gg/IGCSE
Explore our Resource Repository: https://r-igcse.study/

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

It should be a straight line Atlesst 3 points joining together

Look up ggplot for the graph.. It'll do what you want.

You'll need a date variable for the x axis. You should be able to use mutate for that.

Import your data as object df and then run dput(head(df)) and post or dm me the output (the first 6 rows), and I'll get you started

Why you "have" to use R? My non-programmer colleagues at the lab always do their basic graphs on excel, and only when something complex is needed I do some R. The plot you described seems very simple and maybe you can try something more user-friendly.

Without being able to replicate your issue, try adding a group aesthetic, group = grouping_var along side your color aesthetic.

https://www.lido.app/post/google-sheets-charts-2021

(me again!)

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

The best way to do that is to drop the second reference in your chart data source. So for example, if you data source is say ($A$2:$A$434), when you reference that in your chart, just use ($A$2:$A)... That will keep updating the chart as more data gets populated in your reference sheet. Hope it helps!

Edit: Spelling and grammar

Here's how you can do it without pivot stuff - make a table with one column for the date and one column for each person, then do a countif like =COUNTIFS(data_Dates, "<=" & dateInThisRow, data_Names, personForThisColumn) (FYI you can make a quick dates column with e.g. =SEQUENCE(numDaysToShow) + startDate where startDate is either another cell with your desired start date or the date function like DATE(2025, 1, 1)

You can also do it with a pivot table - what you're looking for is (outside of pivot tables) called a cumulative sum. To make a pivot table do it:

• Select your data and do Insert >> Pivot Table
• Drag "Date" field into the Rows section
• Drag "Person" field into the Columns section
• Drag "Person" field in to the Values section
• Click the new "Count of Person" option in the Values section and do Value Field Settings
• Confirm "Summarize Values By" tab has the "Count" option selected
• Go to the Show Values As tab and change the dropdown the "Running Total In" then click OK

/u/LionHeartGames - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

|Fewer Letters|More Letters| |-------|---------|---| |COUNTIFS|Excel 2007+: Counts the number of cells within a range that meet multiple criteria| |DATE|Returns the serial number of a particular date| |SEQUENCE|Office 365+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4|

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^(Beep-boop, I am a helper bot. Please do not verify me as a solution.)
^([Thread #44689 for this sub, first seen 7th Aug 2025, 12:33]) ^[FAQ] ^([Full list]) ^[Contact] ^([Source code])

You could create a table with columns Date and Name where you enter data, and then have a range where you list all dates from the starting date to the ending date and a column for each unique Name from the original table. Use a formula for each cell under each unique Name to count how many records are in the original table for that Name that are less than or equal to the Date in the current row. That would give you a rolling total, which you could then show in a line chart.

Another way of doing it would be to maintain it all in 1 table: every row has a Date and 2 columns for each Name - 1 column for entering the number of tasks on that Date (0 or 1), and 1 column for calculating the rolling total of 0s and 1s for that Name.