D DashboardNovice Member May 23, 2015 #1 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
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.
Hui Excel Ninja Staff member May 23, 2015 #2 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
D DashboardNovice Member May 23, 2015 #3 Hui said: 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 Click to expand... Thank you sir. By the way, is it known how access automatically determines X and Y axis minimum and maximum values?
Hui said: 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 Click to expand... Thank you sir. By the way, is it known how access automatically determines X and Y axis minimum and maximum values?
Hui Excel Ninja Staff member May 23, 2015 #4 Have a read of: http://peltiertech.com/how-excel-calculates-automatic-chart-axis-limits/