Scatter Chart not Showing X-axis Values

[ward0749]

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

[June7]

Never built that kind of graph. I do best analyzing graph issues with data. Do you want to provide project?

[ward0749]

Yes the graph is used to determine a projected absolute open flow rate using a best fit line for 3 or more data points. The issue is that the x axis does not use the Flow rate values in the table, instead it just uses the column numbers.

[June7]

Did not respond to my question.

[ward0749]

Problem fixed itself this morning as I changed the chart type to a line chart then back to a scatter chart.