Plotting a multi-line chart with occurances of events

Sbro187

New member
Joined
Jan 24, 2018
Messages
2
Reaction score
0
Points
0
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;
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
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.
 
A very basic and sraightforward pivot table and chart can probably give you what you want. See attached.
Supply a file if you want more.
 

Attachments

  • ExcelGuru8757.xlsx
    16.4 KB · Views: 18
Thanks for that. I'll give it a try and see if it produces the result I need.
 
Back
Top