From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Visualize data using logarithmic scales

Visualize data using logarithmic scales - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Visualize data using logarithmic scales

“

- [Instructors] Most business data describes dollar amounts in the hundreds, thousands, or hundreds of thousands. A lot of scientific data, particularly in the fields of biology and astronomy, describe much larger quantities. For example, you might have celestial bodies that are millions or billions of miles away, and you can see those distances in light years expressed here using exponents. If you do need to work with data that contains extremely large values, then it makes sense to use logarithmic scales. And I will show you how to do that in a charge in Excel in this movie. My sample file is 0203 logarithmic scale, and you can find that in the chapter two folder of the exercise files collection. This workbook contains distance data for stars and galaxies, so the values are extremely large. But before I get into how to change the chart and what it's actually showing, I want to review exponents and logarithms. An exponent is used to multiply a number by itself. For example, in cell…

Contents