Dynamic Chart that plots all pricing

Hello everyone, I was wondering if I can get assistance in creating a chart that is filterable by several criterias, and would plot the price on the Y axis based on the quantity on the X axis. I have created something close to what I want by creating a line graph and removing the lines but my problem is showing all points, instead of summarized values. Details below

Example of my raw data is below (to protect the privacy of my company):
figure0.JPG

The closest I can come up with is creating a line chart using a pivot (below):
figure 3.JPG

And just removing the lines to just show the points on the chart (below):
figure1.JPG

However, my problem is that not all data is showing mainly because of the summarize value requirement (which in this case I used minimum). prime example is the plot point below:
figure4.JPG

when I show all detail, it shows me 4 different data points, which i need to show in the graph, not as summarized:
figure4a.JPG

I just need a dynamic chart that is filterable based on several categories, would plot all prices on the Y axis and quantity on the X axis without summarizing it. I tried to do this with an XY Scatter, but I cannot make it as dynamic as a line graph.

EDIT: I cannot seem to attach the sampole excel file that I used to illustrate the explanation above, I'm not sure how I can send it

To attach a file pick the Go Advanced button at the bottom right of the posting area.

Then underneath the post area you'll see the 'Manage Attachments' option.

If I understand your request then you DO need to use an XY scatterchart. Unfortunately I don't believe you can create one on the back of a Pivot Table.

You'd need to create a chart from the Raw Data and use Slicers to filter the chart

Slicers work off an Excel Table (as well as Pivot Tables) so first make the data into a pukka table with the Insert Table option.
Then choose Insert Slicers and finally create your XY chart from the Table.