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 ...

Properly formatted charts and graphs can help you grasp the patterns and trends hidden within the raw data of an Excel spreadsheet. For example, if you are comparing the stock performance of two ...

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 ...

If you use Microsoft Excel regularly for studying or work that requires a spreadsheet to be filled with data-driven information, then you know it can be quite difficult and time-consuming to decipher ...

Every time Steven 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 ...

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 ...

One option for sharing reports with your team is to simply rattle off numbers. Think something like this: "We allocated 10% of operating budget to maintenance, 15% to hardware upgrades, 18% to ...

If you do not want to move a chart while changing the width of the cell, you can lock the chart position in an Excel spreadsheet with this guide. Although the chart moves as per the cells’ width and ...

Here’s one bit of weirdness that hasn’t changed in Office 2007: When you create a bar chart from a column of data in Excel it plots the data series in reverse order, starting with the value at the ...