You can determine what your chart displays by choosing a layout. You can use these tabs to customize your chart. The tabs become available when you create a new chart or when you click on a chart. Called Chart Tools, there are three chart context tabs: Design, Layout, and Format. Excel creates a Clustered Column chart and the Chart Tools context tabs appear.Ĭontext tabs are tabs that only appear when you need them. Click the Clustered Column chart sub-type.A list of column chart sub-types types appears. Click the Column button in the Charts group.You must select all the cells containing the data you want in your chart. To create the column chart shown above, start by creating the worksheet below exactly as shown.Īfter you have created the worksheet, you are ready to create your chart. As you roll your mouse pointer over each option, Excel supplies a brief description of each chart sub-type. There are further sub-types within each of these categories. For example, after you choose Column Chart, you can choose to have your chart represented as a two-dimensional chart, a three-dimensional chart, a cylinder chart, a cone chart, or a pyramid chart. After you choose a chart type, such as column, line, or bar, you choose a chart sub-type. You select a chart type by choosing an option from the Insert tab's Chart group.
![how to change axes of a scatter chart in excel 2007 how to change axes of a scatter chart in excel 2007](https://i.stack.imgur.com/JTMYM.png)
As you change your data, your chart will automatically update.
![how to change axes of a scatter chart in excel 2007 how to change axes of a scatter chart in excel 2007](https://i.stack.imgur.com/B8fRh.png)
The basic procedure for creating a chart is the same no matter what type of chart you choose.
![how to change axes of a scatter chart in excel 2007 how to change axes of a scatter chart in excel 2007](https://www.extendoffice.com/images/stories/doc-excel/axis-break/doc-axis-break-22.png)
On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. In Microsoft Excel, you can represent numbers in a chart.