After you have created your Microsoft® Excel® spreadsheet, you can visually represent the worksheet data by creating a chart. Charts often make your data clearer and easier to understand.
If you find that the data is not in sequence or in a group of cells, you may need to create your own series, specifying the labels and values. Data can be extracted from different worksheets and even workbooks.
TIP: To create a quick chart, select any cell within the data range and press F11.
In this tip, we are going to create a combination chart from scratch showing the difference between the Sales and Purchases.