I am having trouble with scatter charts. The data is correct, but I want to be able to select what the axes are. For instance I have selected two columns to display (for my data): Cost of product, and Value for product. I want the scatter to plot the value on the y and the cost on the x (or vise versa), but when I select those two columns only, it plots the product name on the x and the value AND cost on separately (two dots) the y axis. I need it to be one dot that represents the intersection between the cost and value and the dot be labeled with the item name. 

Certainly. I am sorry I wasn't more clear. I have attached a screenshot (#1) of the chart I am having issues with. It has two vertices plotted on the y-axis for each product on the x-axis. I don't want the x-axis to be products, but to be price, and the y-axis to be value. Price and value were the only columns I selected to be in the chart, but instead the chart has made the x-axis the product names and plotted the price and the value as separate vertices above the one product. I want each product to only have one vertex at the point on the y-axis (price) where it meets the x-axis (value) for the product. The second screenshot (#2) is from excel with the same data the way it should be shown.  

While I have you, is there any way to show the trend line on the graph like in the second screenshot? I know that Highcharts has this functionality, but I don't see how to do it in the WP plugin. 

Let me know if you need any further clarification. Thank you for your help and prompt response! 

To be clear. There is no built-in solution for either issue: trend line or picking the axes?