Trying to create a line chart for multiple Vendors/Products

I have a worksheet that looks like this:

This is just a sample. The full sheet includes multiple dates and vendors. On a separate sheet I am trying to create a line chart with the following features:

1. x-axis from Date column
2. y-axis from Price column
3. Results filtered by Product column. A drop down menu allows user to select the Product he wants to track.
4. Multiple lines (color coded with legend) for each Vendor with pricing data for the selected Product

As an example, see below. With the exception of a filter to select different products, this is basically what I am going for.

I have tried inserting a chart in multiple different ways, using recommendations, creating from scratch, etc. I have failed in all my attempts so far to build this out.