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

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