I want to create a chart on excel.
The x-axis is time.
For the y-axis I have two text values, B2C and B2B. Each text value may appear once or more per a date.
I want to graph two lines, one for each text value, based on how many times they appear per a date. So for example one data point for the B2B line might be [2/3/2020, 3] because there were 3 B2B values on 2/3/2020.
Here is an example of some of the values:
25/11/2019 B2C
04/03/2020 B2C
10/06/2020 B2C
26/02/2020 B2B
26/02/2020 B2B
10/02/2020 B2B
17/02/2020 B2B
13/03/2020 B2B
Can someone please help me with this?
Thank you
Bookmarks