The screen shot below shows sales data broken into brands. Highlight cells A1 to C5 and press F11. Excel will automatically open a chart sheet and create a bar chart based on the highlighted information in your workbook.