Where is graph wizard on excel 2007

The range of cells that make up a chart. The chart is updated automatically whenever the information in these cells changes. The vertical and horizontal parts of a chart. The vertical axis is often referred to as the Y axis, and the horizontal axis is referred to as the X axis.

Once you insert a chart, a new set of Chart Tools , arranged into three tabs, will appear above the Ribbon. These are only visible when the chart is selected. You may want to take a few moments to explore the available options. I especially like the predefined chart layouts and chart styles on the Design tab that provide instant professional results. On the Layout tab, I can add all sorts of chart elements or change the way they are displayed in the chart. Living up to its name, the Format tab provides many ways to format a chart using special effects that have never been available in earlier versions of Excel, such as the bevel effects shown in the chart below.

I also want to point out that you can right-click on any chart element for quick access to specific features that can be applied to that element for example, you can get to the Format Axis dialog box when you right-click any chart axis.

Create a chart from start to finish. Free training: Take the next steps in growing your Excel skills Lesson 2. Go beyond the basic chart type. Use sparklines to show data trends. Line or scatter chart? The Series tab splits up the actual data range into individual series.

Step 3 - Options - Lets you define certain options for the chart i. This also displays a preview of how the chart will look. Step 4 - Location - Lets you decide whether to display the chart on a separate chart sheet or as an embedded object on the active worksheet. The advantage of using the Chart Wizard is that you can easily go back and change any of the options before you actually create the chart.

Lets you choose from the 14 different standard types of chart. Lets you select the cells and define the range to use for the chart. Excel will normally default to plotting your series by row although it actually depends on the shape of your data. If your data has an equal number of rows and columns or has more columns than rows then your series are plotted in rows. If your data is non-contiguous then this can vary.

To help you to identify the correct range you can use the button on the right of the Data Range textbox to minimise the dialog box.