Just keep in mind that the data should have headers and no blank rows. You can either work on existing data stored in Excel or you can import data from other applications. Spot data outliers that are unrelated to the rest of the data.Understand the meaning behind the numbers.It is essential to learn how to create a graph in Excel if we want to obtain more information from the data. Excel Charts are visual representations of data that are used to make sense to the gazillion amounts of data jammed into rows and columns.