If you understand the definition of a mathematical function, a good way to judge it is that any line drawn parallel to the y-axis intersects with the values in the function’s curve only once. The same ...

The legend on an Excel scatter plot is simply a list of the names for each of the series on the chart. The legend is color coordinated, so you can quickly determine which data points belong to which ...

Two columns or rows of data in Microsoft Excel may contain useful information, but you'll just have a set of numbers. You can give spreadsheet viewers a graphical representation of those numbers by ...

You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

Every time Ryan publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from Business ...

Tired of erasing holes in your graph paper or having to start over from scratch? Here's an easy way to create your own custom graph paper in Excel. This past week, I started mapping out new flowerbeds ...

If you use Microsoft Excel, you'll recognize that it is a powerful application, capable of acting as a full-featured spreadsheet and data analysis tool. While Excel is fully capable of some powerful ...