To illustrate, look at the screen shot, which shows sales data broken down by zone.
Select a cell in the table, and press F11.
The result:
Excel opens a chart sheet, a sheet in your workbook that contains a new chart.