I'm creating in Excel 2007 2D chart to illustrate throwing an object in gravity on different planets. Everything works fine, but I would like to have axis with the same scale, because now chart doesn't match reality.
Values on axis are taken from the data in the sheet. Any ideas how to do it?
Right click on the vertical axis numbers, (like the 8) and click "Format Axis". Under "Axis Options", change maximum from "Auto" to "Fixed", and input 25.
I did this using Excel 2010, but I believe the process is the same (or similar) in 2007.