Line that goes through lowest points in scatterplot

I do not work with pivot tables, but I do know that trying to chart data from pivot tables can be challenging -- especially when you want an XY scatter chart. http://peltiertech.com/regular-chart...-pivot-tables/

As I indicated, charts are not very good at "analyzing" data. I expect that the real challenge here is how to get your pivot table to extract those "lowest" points into another column (which can be added to the scatter chart as an additional data series). As I have very limited experience with pivot tables, I am likely not going to be much help with this.