Planning a Chart Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition Data marker Horizontal axis Vertical axis Tick marks Data point Legend Plot area Chart elements Data series Planning a Chart Chart elements (cont.) A data point is the value in a cell you select for your chart A data marker visually represents each data point in the chart A group of related data points is a data series A legend makes it easy to identify each data series Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition Objectives Change the chart layout Format a chart Annotate and draw on a chart Create a pie chart Microsoft Office 2007-Illustrated Introductory, Windows Vista EditionĬhart planning guidelines Determine the purpose of the chart and identify the data relationships you want to communicate graphically Determine results you want and decide which chart type is most appropriate Identify the worksheet data you want the chart to illustrate Understand the elements of a chart Planning a Chart Microsoft Office 2007-Illustrated Introductory, Windows Vista EditionĬhart elements The horizontal axis ( x-axis ) is also called the category axis The vertical axis ( y-axis ) is also called the value axis The z-axis is present in 3-D charts Area inside the horizontal and vertical axes is called the plot area The scale of measure on the y-axis is identified by tick marks Planning a Chart Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition Plan a chart Create a chart Move and resize a chart Change the chart design Objectives Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition Working with Charts

Make a pie chart in excel 2007