none
Access Chart shows wrong value range on y axis RRS feed

  • 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:

    Monday, September 26, 2016 4:33 PM

Answers

  • 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.
    • Proposed as answer by David_JunFeng Monday, October 10, 2016 1:21 AM
    • Marked as answer by David_JunFeng Monday, October 10, 2016 1:21 AM
    Tuesday, October 4, 2016 4:45 AM

All replies

  • 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.
    Tuesday, September 27, 2016 2:33 AM
  • 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

    Tuesday, September 27, 2016 2:42 PM
  • 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.
    Wednesday, September 28, 2016 5:59 AM
  • 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

    Wednesday, September 28, 2016 3:32 PM
  • 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. 
    Thursday, September 29, 2016 7:47 AM
  • 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.

    Thursday, September 29, 2016 3:07 PM
  • 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:
    Thursday, September 29, 2016 3:41 PM
  • Hi al.sallam,

    Thanks for your sharing your findings, that will help other community member when they meet same issue.
    Friday, September 30, 2016 9:40 AM
  • 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.
    Friday, September 30, 2016 3:34 PM
  • 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.
    • Proposed as answer by David_JunFeng Monday, October 10, 2016 1:21 AM
    • Marked as answer by David_JunFeng Monday, October 10, 2016 1:21 AM
    Tuesday, October 4, 2016 4:45 AM
  • Thank you David for the link and the information
    Monday, October 10, 2016 1:42 PM