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

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

Q. As a conclusion to each project, we evaluate our project time and cost estimates for accuracy. Obviously, underestimating is a problem, but over-estimating is also a problem that leads to ...

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them. Microsoft Excel offers a plethora of tools for ...

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

line graph – to show a change over time pie chart – show the individual parts that make up a whole bar chart – compare things that aren’t directly related scatter graph – look for a pattern or link ...