A pivot table is a powerful tool in Excel to summarize ... You can right-click on a chart to change the fill and outline color to give it a unique look. You can now click on Month, Sales Person ...