You can make an Excel scatter plot assigning one of the variables in each record to the x-coordinate and one to the y-coordinate on a standard graph axis.

By combining Excel’s GROUPBY function with dynamic formulas, data validation lists, and conditional formatting, you can create an interactive data summary with robust drill-down capabilities.

If you have a number of Microsoft Excel worksheets that contain related data, you'll likely need to create a report that consolidates and summarizes the data. If those worksheets are laid out ...