I have a scatter chart in a form that I want to show Flow Rate versus Pf^2-Ps^2 in Access 2007. The Y values plot correctly in the chart, but X values just plot as 1, 2, 3 in succession. How can I get the X values to plot on the X-axis. I have included a screenshot of the chart and table and the Data Properties. As an extra question, if anyone knows how to transfer the trendline equation into my query or form so that I can use it to calculate other values, help on that would be very appreciated as well. Thanks
![]()