Access 2016 troubles

Question

Hello,

I am using Access 2016 in Office 2016 on Windows 10. I have just upgraded from 2013 to 2016 and are now experiencing great difficulties when making an x/Y diagram.

Values on X-Axis in Diagram are very different form values in query. Why?

Example: in my query x-values range from 0 to 1.2%.

When I create a diagram then values range ftom 0 to 1.2E+12 ?????

Data on the original table are of Single type.

Strange thing is, when I modify my table and define data as Integer multiply with 100 and divide by 100 in diagram query then I get 1.2 % on X-axis scale.

Any idea what is wrong?

Peter

* Changed to a question

Answer 1

Hi, Thanks for your answer.

The original data are created by Access 2016, see table below. all data as I expect and correct. Strain, stress, Tangent and so on, all of single type. So far everything OK.

Next is query for a X/Y diagram

Next is data is from above query, all data are like in original table, all data correct.

Next is diagram. You see all data are way out of line. Data on horizontal line are wrong by 1000,000 , left vertical axis is wrong by 100,000 Why? What happens between query and showing diagram??

Below is how it should look like. To produce this graph I created all data as integer. Modifed all data in original table from single type to integer. Mulitplied all data with 100 and in query I divide by 100. Graph is just fine.

Why is graph totaly wrong if I use single type data? What happens inside between query and display? What goes wrong inside MS Graph?? My Office 2016 including Access is a new update from 2013 to 2016, I did not experience this kind of problem any time before. Access MS Graph is not easy to work with, by far not, I do have lots of experience with MS Graph troubles but never anything like this.

Any idea what I can do to fix it?

Thanks and regards

Peter

Answer 2

Could you show us the SQL of the query that you are using?

Can you show us the chart with the invalid results displayed, annotated to indicate what's wrong with it?

Thank you.