When you make a chart, Excel determines the scale of the Y-axis based on the numbers in your data set. If the range of your data (the difference between the highest and lowest numbers) is greater than 20% of the lowest number in your data set, then the Y-axis of your chart will go from [...]
Tag archives for axis
Trying To Put Large and Small Numbers on an Excel Chart? Try a Logarithmic Axis
Last week I spoke to a staff member who needed to make an Excel chart. Her data set was similar to the one above with Y axis values varying from 30 to 10,000. The resulting chart was similar to the one below, which is based on the sales data at the top of this post. The lowest [...]
category: Excel
About
The McCombs Technology Training Team helps UT Austin business students, faculty, and staff with their technology resources, and with Microsoft Office. The trainers are Holly Green and Ben Bond.
Jeff Hauger, a previous team member, contributed several blog posts.
