Chart showing cumulative user number growth by country

[Lizat]

I am doing some simple stats for our site - eventually we will use a proper BI tool but for now a spreadsheet will do. I want to show member numbers over time and by country. So it is the running total for each country xaxis is time, y is cumulative number and there would be an ascending line for each country.
The data set is a list of users and includes the date of joining, I have columns for Month and Year, and their home country.

What is the best way of doing this?

Thank you
This is a small sample file, the Person tab is the data:

Users.ods (34.4 KB)

[Hrbrgr]

A file with the data would be very helpful.
Please upload the file here so someone can look at it.
Thank you very much.

[Lizat]

Done, thanks

[Lizat]

Have uploaded file on the original post

sorry, meant to comment and mouse slip! so it 's flagged as a solution but can’t delete it.

[Hrbrgr]

You can also transpose a table if it is not arranged correctly according to your wishes:

Transpose Tables in Calc

The arrangement in the table determines the appearance of the chart.
See the transposed sample.

HB_01 Users.ods (41,8 KB)

[Lizat]

Yes I can do that what I can’t work out is how to have Time across the bottom, numbers vertically and a cumulative total by country so that I see e.g. a yellow line for brazil starting at zero and running to today’s cumulative total of say 100,. and a blue line for the UK starting at zero and running to today’s cumulative total of say 500 showing cumulative growth across time and for all countries on the same chart. I think I need to pivot and then chart, but can’t work out how to get eth cumulative total by month… I am sure it simple I just have a mental block!

[Lizat]

Mental bock defeated… Have now found a way to add a running tatal to a pivot table ( add data item double click to see the mode, use Count and also click to add the display or running total in Month)