Under Axes, click Axes > Vertical Axis, and then click the kind of axis label that you want. I've created the logarithmic scale, but it won't get into the format I would like it to be in. Show "zero" value on Excel logarithmic scale graphs axis, View this "Best Answer" in the replies below ». Tip Changing the display unit is useful when the chart values are large numbers that you want to appear shorter and more readable on the axis. Note: The number that you type determines how many categories are displayed between the tick marks. 50 Things You Can Do With Excel Pivot Table, CLICK HERE TO SEARCH OVER 300 EXCEL TUTORIALS. Something in there will do your bidding. Since we don't know this professor nor his or her expectations, nor even the conventions in whatever area you might be working in, that's a little difficult. When the values that are plotted in the chart cover a very large range, you can also change the value axis to a logarithmic scale, also known as log scale. So it depends what you're going to do with the trend-lines. A model that predicts the test objects will get heavier without limit as time goes on isn't prima facie a very suitable one. This scales the chart to show a more even spread, like the image below: *** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***. Even though we’re not really good at nonlinear scales, the line chart doesn’t give us the initial bar-length-equals-value precognitive impression to overcome. I plotted a graph in excel with time as x axis and weight as y axis. DOWNLOAD OUR FREE EXCEL RESOURCE GUIDE E-BOOK! In Excel 2016, box and whisker plots are now available, but it appears that a log-scale for the Y axis is not possible? Then, in effect, you'll have a 0 on your y-axis. By default, the minimum and maximum scale values of each axis in a chart are calculated automatically. Are vintage devices compatible with iCloud? Point should be slightly higher than they are now, had I not disturbed the Process with my measurements. So simple! Instead of entering zero, you can enter a low value (say -10 on the log scale), and then use custom ticks to label the graph correctly (so it is labeled "0" rather than "-10". A better model would take into account prior engineering knowledge about the form relationships could take. Point should be slightly higher than they are now, had I not disturbed the Process with my measurements. How does linux retain control of the CPU on a single-core machine? By default, Microsoft Office Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. Follow Limey's instructions if you require different scales or if you specifically want to use Excel. Yes, I tried that, but it doesn't let me change the "Minimum" value, is set to 1.0, but if I change it to 0, Excel changes it back to 1.0! Therefore 3. and 4. However, on a regular chart, you would adjust the numbers in Axis Options. This would result in a logarithmic weight gain. Cross Validated is a question and answer site for people interested in statistics, machine learning, data analysis, data mining, and data visualization. To change the point where you want the vertical (value) axis to cross the horizontal (category) axis, expand Axis Options, and then under Vertical axis crosses, select At category number and type the number that you want in the text box, or select At maximum category to specify that the vertical (value) axis cross the horizontal (category) axis after the last category on the x-axis. Great GretchenR! Why use "the" in "than the 3.5bn years ago"? To change the value axis to logarithmic, select the Logarithmic scale check box.