The data selected to create a chart must include a series of data, located in the worksheet. The series of cells that contain the data are to be selected and used in the chart. The graph will show the differences between the given data. Charts are commonly used to show the difference between a set of things, or to represent something of a whole.