Show All

Hide All

The Chart menu is available only when you have created and selected a chart that is embedded in a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) or displayed on a separate chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.). The Chart menu provides commands for modifying a chart but not for creating a chart.

1. To create a chart, click the Chart Wizard on the Standard toolbar, or click Chart on the Insert menu, and then follow the steps of the wizard.
2. To display the Chart menu on the menu bar, click anywhere in the chart, or select a chart sheet.