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

A scatterplot chart graphs two related data values as a single dot by plotting one value on the horizontal X axis and the other value on the vertical Y axis. For example, you could plot an employee's ...

We all know that Excel can make some gorgeous charts and graphs, but if you are like 30 Rock's Liz Lemon and don't know your scatter plot from your triangle graph ("I don't know. It sounded real!"), ...

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