Access Chart shows wrong value range on y axis

Question

I am having a problem when plotting the above data, they Y access shows zeros and ones, it does not show the actual values shown on the graph above. I checked the chart options and saw that the Z axis was checked not the Y, not sure how to fix this to show the right values instead of the zeros and ones. see images above:

Answer 1

Hi al.sallam,

According to your description, as far as I know that Pivot chart reporting was removed in Access 2013, you could do is create a data connection to access then do the chart in excel.

For more information, please refer to Discontinued features and modified functionality in Access 2013

In addition could you provide more information about this issue, for example Access version, screenshot etc., that will help us reproduce and resolve it.

Thanks for your understanding.

Answer 2

Hi David,

thank you for your reply. I pasted 2 images to show the data and chart, but apparently it did not save them. I am re attaching them. let me know if you could see them

Answer 3

Hi al.sallam,

Thanks for your sharing chart screenshot, we are able to see them. Could you provide detail steps about how to create this chart, that will help us reproduce and resolve your issue.

Thanks for your understanding.

Answer 4

I am loading several screen shots to show different items on building the chart with their details

Here is the source query:

Here is char options:

Here is the Y (Z) axis scale:

Here is the Y (Z) axis number tab format:

Please let me know if you need something else specific. thanks

Answer 5

Hi al.sallam,

Based on your screenshot, which version is Excel and Access? do you create chart in Excel? If so, if you create this chart with fake data in Excel, what do you get?

Thanks for your understanding. 

Answer 6

All the screen shots I loaded here, are Access, however, to answer your question regarding Excel and Access version, it is 2013. I used Excel and it was fine, see below. I am not sure why would Microsoft remove an important feature as 'Pivot chart reporting was removed in Access 2013' as per your first answer. this is a very simple graph that Access should be able to perform.

Answer 7

David, I re did this in access and noticed that if the graph is not stacked, the y axis shows fine, it is when it is stacked  it messes up the y axis. here is comparison between excel and access:

Answer 8

Hi al.sallam,

Thanks for your sharing your findings, that will help other community member when they meet same issue.

Answer 9

we still did not resolve the problem David, How can I accomplish the same in Access, that was the question. I know it works in Excel but that won't help me. There has to be a way to resolve this in Access, this is very simple graph.

Answer 10

Hi al.sallam,

According to your description, I have reproduced this issue, this workaround is that you could create chart in Excel, then right click on the chart and copy to Access Form.

In addition you could submit any feedback to Access User Voice:

https://access.uservoice.com/

Thanks for your understanding.

Answer 11

Thank you David for the link and the information