These five charts are helpful in the representation of a data.

Named ranges are important in Excel and are recommended by almost every Excel expert. 5 benefits of using named ranges in Excel