ppt课件-creatingcharts-universityofnorthtexas.pptVIP

CREATING CHARTS By: Dr. Ennis - Cole OBJECTIVES Identify the elements of an Excel chart Identify the type of chart represents your data most effectively Create an embedded chart Move and resize a chart Edit a chart Change the chart’s appearance OBJECTIVES Place a chart in a chart sheet Select nonadjacent ranges Work with 3-D chart types Add a picture to a chart Starting Excel and Renaming a File Start Excel Open the workbook Documentation appears as the first sheet in the workbook Type your name and date in the cells Save the workbook The new filename appears in the title bar EXCEL CHART TYPES Refer to figure 4-2 for Excel chart types Refer to figure 4-3 for chart subtypes for column chart type Refer to Figure 4-4 for the following Excel chart elements: Chart area - is the entire chart X-axis - horizontal axis Y-axis - vertical axis EXCEL CHART TYPES A tick mark label - identifies the categories, values or series in the chart A tick mark - small line that intersects an axis Grid lines - extend the tick marks to make it easier to see the values of data markers EXCEL CHART TYPES Data point - is a single value originating from a worksheet cell Data marker - a graphic representing a data point in a chart Data series - a group of related data points PLANNING A CHART Identify the data points to be plotted Choose an appropriate chart type Sketch the chart Decide on the chart’s location Refer to Figure 4-5 CREATING A COLUMN CHART Select the data Click the Chart Wizard Button Follow the series of steps Click the Column chart type Press and Hold to View Sample button Click Next Button Follow the steps to to change data series Moving and Resizing a Chart Select the chart Position the pointer, click and hold down the mouse and drag the chart Release the mouse to view the chart in the new position Hold and drag the mouse button to resize Refer to Figure 4-14 Update and Modify a Chart Click the cell that needs correction Type the content and press Enter Select