CHARTS
Transcript: 2. Choose Insert . Charts, and then select the arrow beneath the chart style you want: Excel can create many different chart types which compare data in different manners. 2. Choose Chart Tools>Design>Type>Change Charge Type. The change charge type dialog box appears. ADJUSTING THE CHART LOCATION 1. Click on anywhere on the chart you want to change. 2010 CHART TYPES: Press F11 to open a new sheet called Chart1 to your workbook with the data plotted into a column chart. Each subsequent chart page is numbered sequentially such as Chart2, Chart3, and so forth. b. Bar -Like column charts, it compares values to categories, but use a series of horizontal bars to illustrate the series. 5. The More Legend Options box offers the same type of formatting options as the Chart Title. Choose any desired options. Click OK. f. X-Y Scatter -This includes two values axes, one showing a set of numerical data along the x-axis and the other showing data along the y-axis. e. Area -This displays the trend of each value, usually over a specified period of time. h. Doughnut -This displays data similarly to a pie chart; it compares parts to a whole, but contains multiple series. 2001 j. Radar -This displays changes in values relative to a center point by comparing the cumulative values of multiple data series. Rule 3 Blank rows and columns in your information are not changed. 4. Click Chart Tools>Layout>Labels>Legend>More Legend Options. INSERTING A CHART k. Bubble -This is similar to scatter charts, but it compares three sets of values by displaying a series of circles. are graphical figures of data in worksheet. this can then be moved, resized, and deleted without affecting your data. it do not appear within a specific cell, but ratherappear over other cells. CREATING A BASIC CHART Rule 6 If the data contains an equal number of rows and columns, the data will be plotted by rows by default. You will then have the option to plot by columns. 3. Select a location: Rule 4 If the data contains more arrows than columns, the data will be plotted by column. The first column becomes the x-axis labels; the balance of the columns are the data series. The first row becomes the legends labels. g. Surface -This shows trends in values in a continuous curve. a. New Sheet creates a new worksheet and places the chart on the sheet. 3. Select the different chart type and subtype you want. Rule 1: *A chart title is automatically added to your chart based on the first row of selected information. The chart title, however, can be added anytime you want. CUSTOMIZING THE CHART LEGEND 2. Click Chart Tools>Layout>Labels>Legends. i. Stock -This is usually used to illustrate the fluctuation of stock prizes. In a stock chart, the data order is very important and usually the row headings are High, Low, and Close; or Open, High, Low, and Close. 2004 2. On the Design tab, choose Location Move Chart. The Move Chart dialog box appears. Select the data (sequential or (nonsequential) you want to plot in the chart. 1. Select the chart by clicking on it, whether it appears on its own sheet or on data worksheet. A Chart Tools tab with three sub tabs appears. 4. Click OK. The existing chart is then modified. c. Line -Similar to bar charts but use dots to represent the data points and lines to connect the data points. 2013 Rule 5 If the data contains more columns than rows, the data by will be plotted by row. The first row becomes the x- axis labels; the balance of the rows are the data series. The first column becomes the legend's table. 1998 3. Select a placement for the legend or click None to turn off the chart legend. b. Object in moves the chart to an existing sheet in the workbook. Click the drop-down arrow to select the worksheet to which you want to move the chart. Rule 7 If only numeric data is selected, rules 4 and 5 are followed. CHANGING THE CHART TYPE 1. Select the data you want to plot in the chart. a. Column - it starts and compare values to categories using a series of vertical columns to illustrate the series. d. Pie - This chart compares parts to a whole. Usually a pie chart only has one data series. 3. Choose a chart subtype. Depending on the chart type, some chart subtypes show the data series next to each other; others show the data elements stacked on top of each other. Some charts are two-dimensional, and others are three-dimensional. Excel creates the chart in the worksheet where your data are entered. Rule 2 A chart subtitle is not automatically added to your chart based on the second row of selection information. A subtitle can be added after a chart is created. RULES ON MAKING CHARTS 1. Click anywhere on the chart that you want to move. CHARTS l. Cylinder, Cone, and Pyramid -This is used to create a column or bar chart using three-dimensional cylindrical, conical, or pyramid shapes.