How to Put Two Sets of Data on One Graph in Excel. One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as ...

How to Plot Two Things on the Same Y Axis in Excel. Properly formatted charts and graphs can help you grasp the patterns and trends hidden within the raw data of an Excel spreadsheet.

SEE: 98 Excel tips every user should master (TechRepublic) How to use VLOOKUP () to compare two sets of data in Microsoft Excel The VLOOKUP () function has been the cornerstone of many Excel apps.

Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...