Excel becomes more intuitive once you start using UNIQUE, SORT, and FILTER together. This Excel Trick Ends the Pain of Resizing Tables ...

Click OK. The chart will open on a chart sheet. How to move the chart to a different Excel sheet in the same workbook Before doing this, have more than one worksheet tab open.