Category: Entertainment

Presentation Description

No description available.


Presentation Transcript

Slide 1: 

Lesson 9 Building Charts

Lesson Objectives : 

Lesson Objectives View and print charts. Work with chart elements. Create charts. Edit chart data. Use images, gradients, and textures for a data series. Create a combination chart.

Viewing and Printing a Chart : 

Viewing and Printing a Chart A selected chart is surrounded by a light background frame. The selection handles appear as three or four dots arranged in a line or triangle shape. The data for the chart is usually outlined in the worksheet when the chart is selected.

Viewing and Printing a Chart : 

Viewing and Printing a Chart

Viewing and Printing a Chart : 

Viewing and Printing a Chart When the chart is selected, you can print it by itself. When the chart is not selected, the chart and its data print on the same sheet.

Working with Chart Elements : 

Working with Chart Elements

Working with Chart Elements : 

Working with Chart Elements

Changing the Chart Layout : 

Changing the Chart Layout Select the chart and choose a new layout from the gallery.

Changing the Chart Style : 

Changing the Chart Style The Chart Styles gallery has color and effect variations based on the document theme.

Formatting Chart Objects : 

Formatting Chart Objects In addition to the Chart Tools command tabs, you can use the Mini toolbar to format some chart objects.

Using the Shape Styles Gallery : 

Using the Shape Styles Gallery Shape styles include preset outline, fill, and effects for a chart’s data series.

Setting Shape Effects : 

Setting Shape Effects Shape effects include shadows and bevels. These effects can be used in addition to the Styles Gallery or instead of it.

Creating Charts : 

Creating Charts What data should be used in the chart? What type of chart is best for that data? When you create your own chart, there are two questions that you should consider.

Creating Charts : 

Creating Charts Column charts show how values change over a period of time or make comparisons among items. They can be prepared with 3-D effects or stacked columns. Categories are on the horizontal axis (x), and values are on the vertical axis (y).

Creating Charts : 

Creating Charts Line charts show trends in data over a period of time. They emphasize the rate of change. Lines can be stacked and can show markers, a symbol that indicates a single value. 3-D effects are available.

Creating Charts : 

Creating Charts Pie charts show one data series and compare the sizes of each part of a whole. Pie charts should have six or fewer data points to be easy to interpret. A pie chart can use 3-D effects and can show exploded slices.

Creating Charts : 

Creating Charts Bar charts illustrate comparisons among items or show individual figures at a specific time. Categories are on the vertical axis (y). Values are on the horizontal axis (x). The shape can also be a cone, a cylinder, or a pyramid.

Creating Charts : 

Creating Charts Area charts look like colored-in line charts. They show the rate of change and emphasize the magnitude of the change. 3-D effects are available.

Creating Charts : 

Creating Charts Scatter charts are used to show relationships between two values, such as comparing additional advertising to increased sales. Scatter charts do not have a category; both axes show numbers/values .

Creating Charts : 

Creating Charts Stock charts are often called “high-low-close charts.” They use three series of data in high, low, close order. Surface charts illustrate optimum combinations of two sets of data. They show two or more series on a surface. Doughnut charts compare the sizes of parts and show the relative proportion of the whole. A doughnut chart can show more multiple data series in concentric rings.

Creating Charts : 

Creating Charts Bubble charts compare sets of three values. They are like scatter charts with the third value displayed as the size of the bubble. Radar charts show the frequency of data relative to a center point and to other data points. There is a separate axis for each category, and each axis extends from the center. Lines connect the values in a series.

Editing a Single Column : 

Editing a Single Column While the British Columbia data point (column) is selected, you can change only its color.

Editing a Single Data Point : 

Editing a Single Data Point Formatting changes would affect only the Alberta slice.

Moving a Chart : 

Moving a Chart An object chart can be moved to its own sheet, or a chart sheet can be moved to the worksheet.

Editing Chart Data : 

Editing Chart Data Adding the Ontario data point to the pie chart.

Editing Chart Data : 

Editing Chart Data By keying another column of values, you would be able to add a second data series to a related chart.

Using Images, Gradients, and Textures : 

Using Images, Gradients, and Textures You can use an image, a gradient, or a texture for the fill of a chart shape (the bar, the column, the pie slice). When using these types of fills, it is best to use a 2-D chart style.

Using an Image : 

Using an Image The image can be stretched, scaled, or both to fit the shape.

Using a Gradient : 

Using a Gradient A gradient is a blend of colors. There are preset gradients, and you can build your own.

Using a Texture : 

Using a Texture

Creating a Combination Chart : 

Creating a Combination Chart A combination chart with two chart types and a secondary axis

Summary : 

Summary Charts can be objects in a worksheet, or they can be separate chart sheets. A chart is linked to the data that it is plotting. If the data is edited, the chart reflects the changes. A chart includes many individual elements that can be formatted and edited. Right-click a chart element to see its shortcut menu.

Summary : 

Summary Charts show data series, which are the chart’s values. A pie chart can have only one series, but other types of charts can show multiple data series. You can make many chart changes directly on the chart. If you select data and press [F11], Excel creates an automatic column chart sheet. Excel’s standard types of business charts include bar, column, line, and pie charts.

Summary : 

Summary Move a chart by selecting it and dragging it. Size a chart by dragging one of its selection handles. After a chart is created, you can add a data point or an entire series to it. Although charts typically use solid color for columns, slices, and bars, you can use images, textures, or gradients to add visual appeal to your charts.

Summary : 

Summary You can apply effects to the shapes used in a chart to include shadows, glows, bevels, and more. A combination chart has at least two series and uses different chart types for each series. Some combination charts use a single chart type but a secondary axis because the series values are disproportionate.

authorStream Live Help