• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How could you scale a graph properly

In the attached file, my X axis is somehow way out of proportion to the Y axis. How can I scale the X and Y axis properly?

I would like to do this while being able to accommodate changing values based on user input.
 

Attachments

  • How to Scale Graph.xlsx
    16.5 KB · Views: 0
Right click on the Y Axis
Format Axis
St the Axis Min/Max as applicable
I'd suggest -1000, 500 or Automatic

There is nothing wrong with the X Axis
 
Right click on the Y Axis
Format Axis
St the Axis Min/Max as applicable
I'd suggest -1000, 500 or Automatic

There is nothing wrong with the X Axis

Thank you sir.

By the way, is it known how access automatically determines X and Y axis minimum and maximum values?
 
Back
Top