Hey,
I need a little bit of help here. Basically I want to create a means of plotting the occurrence of several different events (different lines) against the date which they occurred.
For example, I want to have three columns of data;
I want the second column to be a drop down list which only have certain things. Since I'm only interested in certain events (say 7 different events.)
How do I accomplish this?
I need the spreadsheet to;
a) Identify what the occurrence is.
b) Identify when it occurred.
I then want to plot this on a multi-line plot.
Thanks for any help. I've been away from excel for far too long.
I need a little bit of help here. Basically I want to create a means of plotting the occurrence of several different events (different lines) against the date which they occurred.
For example, I want to have three columns of data;
Date | Type of Occurrence | Number of Occurrences |
1/22/18 | Banana | 3 |
1/22/18 | Apple | 2 |
1/24/18 | Banana | 3 |
1/26/18 | Orange | 7 |
How do I accomplish this?
I need the spreadsheet to;
a) Identify what the occurrence is.
b) Identify when it occurred.
I then want to plot this on a multi-line plot.
Thanks for any help. I've been away from excel for far too long.