Warning: Keywords and tricky phrases may not be correctly being used here. I'm not extremely knowlegable about the terms used with Microsoft Excel so I'm using my best guess.
I'm failing to find a simple means of creating a Scatter or Line chart in Excel given 3 columns: NumberMatches, DateOfMatch, and IP_AddressMatchedTo. The goal is a Y axis of NumberOfMatches and X-Axis of Time mapped to DateOfMatch and each IP address has its own line to represent event changes over time. The problem experienced is that I'm failing to find means of rapidly grouping each IP address to its own set of data.
Is there any way to logically group sets of data to a particular line in the chart so that the cumbersome task of grouping them is avoided?