Charts & Graphs

Chart Title 45,000

40,000

35,000

30,000

25,000

20,000

15,000

10,000

5,000

-

Jan

Feb

Mar

Apr

May

Jun

Western Region

Jul Eastern Region

Aug

Sep

Oct

Nov

Dec

Creating Charts and Graphics Getting Started Making Charts Learning Advanced Charting Visualizing Data Using Conditional Formatting Creating Sparkline Graphics Enhancing with Pictures and Drawings 1

What is a Chart? A chart is a visual representation of numeric values. Charts (also known as graphs).

2

Advantages of Using thhe Charts? Displaying data in a well-conceived chart can make your numbers more understandable. Bec a chart presents a picture, charts are particularly useful for summarizing a series of numbers their interrelationships. Making a chart can often help you spot trends and patterns that may otherwise go unnoticed.

3

Understanding How Excel Handles Charts 1. 2. 3. 4. 5. 6. 7.

Before you can create a chart, you must have some numbers — known as Data The data, of course, is stored in the cells in a worksheet. Normally, the data that a chart uses resides in a single worksheet, different Worksheet or w A chart is essentially an object that Excel creates upon request. This object consists of one or more data series, displayed graphically. The appearance of the data series depends on Selected Chart type For example, if you create a line chart that uses two data series, the chart contain two line each representing one data series 8. The data for each series is Stored in a separate row or column 9. Each point on the line is determined by the value in a single cell and is represented by mar 10. You can distinguish each of the lines by its thickness, line style, color, or data markers (sq

4

Illustration 2 Represents Data by Region A key point to keep in mind is that charts are dynamic. In other words, a chart series is linked to the data in your worksheet. If the data changes, the chart is updated automatically to reflect those changes. After you create a chart, you can always change its type, change the formatting, add or remove specific elements (such as the title or legend), add new data series to it, or change an existing data series so that it uses data in a different range. A chart is either embedded in a worksheet or displayed on a separate chart sheet. It’s very easy to move an embedded chart to a chart sheet (and vice versa). Important Selection of Data Markers

Grid Lines Data Lables Formatting Axis Formatting Legend Chart Elements Filtering Colours 5

Two type of Charts: Embedded and Chart Sheets Embedded charts An embedded chart basically floats on top of a worksheet, on the worksheet’s drawing layer As with other drawing objects (such as Shapes or SmartArt), you can move an embedded chart, resize it, change its proportions, adjust its borders, and perform other operations. Using embedded charts enables you to print the chart next to the data that it uses. To make any changes to the actual chart in an embedded chart object, you must click it to activate the chart. When a chart is activated, Excel displays the Chart Tools context tab. The Ribbon provides many tools for working with charts, and even more tools are available in the Format task pane. Chart Sheets Exception : Charts created using F11 It Creates in a Separate Worksheet

6

Moving Embedded Charts to Chart Sheets To move an embedded chart to a chart sheet, click the chart to select it and then choose Chart Tools ➪ Design ➪ Location ➪ Move Chart. Click OK, the chart is moved, and the new chart sheet is Activated

When you place a chart on a chart sheet, the chart occupies the entire sheet. If you plan to print a chart on a page by itself, using a chart sheet is often your better choice. If you have many charts, you may want to put each one on a separate chart sheet to avoid cluttering your worksheet. This technique also makes locating a particular chart easier because you can change the names of the chart sheets’ tabs to provide a description of the chart that it contains. The Excel Ribbon changes when a chart sheet is active, similar to the way it changes when you select an embedded chart. You have access to the same editing tools for embedde charts and charts on chart sheets. If the chart isn’t fully visible in the window, you can use the scroll bars to scroll it, or adjust the zoom factor to make it smaller. You can also change its orientation (tall or wide) by choosing Page Layout ➪ Page Setup ➪ Orientation. 7

Creating and Customizing Chart Creating a chart is fairly simple: 1 Make sure that your data is appropriate for a chart. 2 Select the range that contains your data. 3 Select the Insert tab and select a chart type from the Charts group. These icons

4

display drop-down lists that display subtypes. Excel creates the chart and places it in the center of the window. (Optional) Use the various tools and commands to change the look or layout of the chart or add or delete chart elements.

Experimenting Different type of Charts Working with Charts • Resizing and moving charts • Copying a chart • Deleting a chart • Adding chart elements • Moving and deleting chart elements (Legends, Tiltles, and Data Lables) • Formatting chart elements • Printing charts

Understanding Chart Types Choosing the correct chart type is often a key factor in the effectiveness of the message. Therefore, it’s often well worth your time to experiment with various chart types to determine which one conveys your message best. In almost every case, the underlying message in a chart is some type of comparison. Examples of some general types of comparisons include • Comparing an item to other items: A chart may compare sales in each of a company’s sales regions. • Comparing data over time: A chart may display sales by month and indicate trends over time. • Making relative comparisons: A common pie chart can depict relative proportions in terms of pie “slices.” • Comparing data relationships: An XY chart is ideal for this comparison. For example, you might show the relationship between monthly marketing expenditures and sales. • Comparing frequency: You can use a common histogram, for example, to display the number (or percentage) of students who scored within a particular grade range. • Identifying outliers or unusual situations: If you have thousands of data points, creating a chart may help identify data that isn’t representative.

Different Type of Charts (Practice) Column charts Probably the most common chart type is the column chart, which displays each data point as a vertical column, the height of which corresponds to the value. The value scale is displaye on the vertical axis, which is usually on the left side of the chart. You can specify any number of data series, and the corresponding data points from each series can be stacked on top of each other. Typically, each data series is depicted in a different color or pattern. Column charts are often used to compare discrete items, and they can depict the differences between items in a series or items across multiple series. Excel offers seven columnchart subtypes.

Bar charts A bar chart is essentially a column chart that has been rotated 90 degrees clockwise. One distinct advantage to using a bar chart is that the category labels may be easier to read. The category labels are lengthy, and displaying them legibly with a column chart would be di Excel offers six bar chart subtypes. Line charts Line charts are often used to plot continuous data and are useful for identifying trends. For example, plotting daily sales as a line chart may enable you to identify sales fluctuations over time. Normally, the category axis for a line chart displays equal intervals. Excel supports seven line chart subtypes. Pie charts A pie chart is useful when you want to show relative proportions or contributions to a whole. A pie chart uses only one data series. Pie charts are most effective with a small number of data points. Generally, a pie chart should use no more than five or six data points (or slices). A pie chart with too many data points can be very difficult to interpret. XY (scatter) charts Another common chart type is an XY chart (also known as scattergrams or scatter plots). An XY chart differs from most other chart types in that both axes display values. (An XY chart has no category axis.) Area charts Think of an area chart as a line chart in which the area below the line has been colored in. Stacking the data series enables you to clearly see the total, plus the contribution by each se Radar charts A radar chart is a specialized chart that has a separate axis for each category and the axes extend outward from the center of the chart. The value of each data point is plo Surface charts Surface charts display two or more data series on a surface. Unlike other charts, Excel uses c not to distinguish the data series. The number of colors used is determined by the major unit scale setting for the value axis. Each color corresponds to one major unit. Bubble charts Think of a bubble chart as an XY chart that can display an additional data series, which is represented by the size of the bubbles. As with an XY chart, both axes are value axes (there is no category axis). Stock charts Stock charts are most useful for displaying stock-market information. These charts require three to five data series, depending on the subtype.

nown as graphs).

Illustration - 1

more understandable. Because arizing a series of numbers and

ay otherwise

known as Data

et, different Worksheet or workbook

Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Sales 186,983 179,009 193,422 185,956 196,025 140,323 139,302 134,922 184,773 201,233 218,039 240,093

, the chart contain two lines

Column Chart (Insert/Recommended Charts) A quick analysis using the charts indicates the tre

and is represented by marker e, color, or data markers (squares, circles, and so on).

rds, a chart series is t is updated automatically

he formatting, add or ta series to it, or change

ate chart sheet. It’s very

Illustration - 2 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Western Region 39,823 37,016 35,192 31,540 31,390 31,333 29,441 26,217 23,861 20,601 19,645 19,861

Eastern Region 18,032 18,265 20,176 21,115 21,248 21,336 20,837 20,412 21,262 22,495 25,251 27,127

Illustration - 3 Month Jan Feb Mar Apr May Jun

worksheet’s drawing layer an move an embedded orm other operations. data that it uses.

ject, you must click it to hart Tools context tab. more tools are available

Sales Calls Units Sold 621 45 897 87 1032 150 765 112 802 121 921 143

ect it and then choose

ntire sheet. If you plan to better choice. If you have heet to avoid cluttering art easier because you iption of the chart that it

the way it changes editing tools for embedded

bars to scroll it, or orientation (tall or

harts group. These icons

Practice #1

Customer Satisfaction by Age Group Percent 'Very Satisfied' by customer age Month Jan Feb

< 30 42% 39%

30-49 46% 51%

50+ 75% 76%

ates the chart and places it

ge the look or layout

Mar Apr May Jun

29% 33% 48% 51%

38% 39% 53% 57%

73% 75% 70% 78%

Chart Title 100% 80% 60% 40% 20% 0%

Jan

Feb

Mar < 30

eness of the message. us chart types to determine

ype of comparison.

each of a company’s

and indicate

ative proportions

rison. For eting expenditures

mple, to display ular grade range. of data points,

displays each data point The value scale is displayed ou can specify m each series can be d in a different color or

can depict the differences ers seven columnchart

30-49

Apr 50+

May

Jun

degrees clockwise. One may be easier to read. a column chart would be difficult.

or identifying trends. For ntify sales fluctuations al intervals. Excel supports

contributions to a ffective with a small han five or six data y difficult to interpret.

rams or scatter plots). isplay values. (An XY

ne has been colored in. he contribution by each series.

ch category ue of each data point is plotted on the corresponding axis.

other charts, Excel uses color to distinguish values, termined by the major major unit.

al data series, which is xes are value axes

on. These charts require

y

260,000 240,000 220,000 200,000 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 -

sales by month

Jan

Feb

Mar

Apr May Sales

Jun Jul Aug Linear (Sales) x

Sep

Oct

Nov

Dec

ommended Charts) charts indicates the trend of the sales

Chart Title

Title

45,000 40,000 35,000 30,000 25,000 20,000 15,000 10,000 5,000 -

Western Region Eastern Region

J a n Fe b M a r A p r M a y J u n J u l A u g S e p O c t N o v D e c

month

Chart Title 1200

160

1032150

1000

897 765 112

800 621

802 121

921

120 100

87

600

80 60

400

45

40

200 0

143 140

20 Jan

Feb

Mar Sales Calls

Apr Units Sold

May

Jun

0

Jun

Nov

Dec

Western Region Eastern Region

Chart Title Chart Area

Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Visitors 7,092 7,497 7,560 5,796 13,984 18,743 15,434 14,545 17,434 16,984 15,983 27,822

Column Chart 30,000

Visitors

25,000 20,000 15,000 10,000 5,000

Visitors

0

Line

Jan Feb Dec Nov Oct Sep Aug Chart Jul Jun May Apr 30,000 Mar Feb 25,000 Jan 0 20,000

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Visitors

5,000

10,000

15,000

20,000

15,000 10,000 5,000 0 Jan

Pie Chart

Visitors

Feb

Mar

Apr

May

Jun

Jul

Aug

Visitors

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Bar Chart

rs

Visitors Jul

Aug

Sep

Oct

Nov

Dec 30,000 25,000

Area Chart 20,000

Visitors

15,000 10,000 5,000

15,000

Jun

20,000

Jul

Aug

25,000

Sep

30,000

Oct

Nov

Dec

Radar Chart

Visitors Dec Nov

Jan Feb 40,000 Mar 20,000

0 Jan

Feb

Mar

Dec

Visitors Dec Nov Oct

Jan Feb 40,000 Mar 20,000 0

Apr

Sep Aug

May Jul

Jun

30,000

Visitors

25,000 20,000 15,000 10,000 5,000 0 Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Month Jan Feb Mar Apr May

Widgets

Sprockets 60,983 56,732 49,831 43,323 39,879

64,983 68,981 77,398 88,091 93,733

Chart Title 100,000 90,000 80,000 70,000 60,000 50,000 40,000 30,000 20,000 10,000 0

Jan

Feb

Mar 160,000 Widgets Sprockets 140,000

A

120,000 100,000 80,000 60,000 40,000 20,000 0

Jan

b

Chart Title

Chart Title Mar 160,000 Widgets Sprockets 140,000

Apr

May

120,000 100,000 80,000 60,000 40,000 20,000 0

Jan

Feb Widgets

Sprockets Mar

Apr

May

Item Store locations are convenient Store hours are convenient Stores are well-maintained I like your web site Employees are friendly You have a good selection of products I like your TV ads You sell quality products Overall, I am satisfied I would recommend your company

Strongly Agree 12% 15% 9% 18% 2% 16% 5% 24% 6% 3%

Agree 14% 18% 11% 32% 6% 19% 9% 21% 28% 9%

Undecided 21% 24% 32% 32% 32% 32% 32% 28% 24% 20%

Chart Title Chart Title

0%

Strongly Disagree

I would recommend your company Overall, I am satisfied 0% 5% 10% 15% 20% Chart 25% You sell quality products I like your TV ads Title of products You have aChart good selection Employees are friendly I like your web site I would recommend your company Stores are well-maintained Overall, I am satisfied Store hours are convenient You sell quality products Store locations are convenient 20% 40% 60% Agree 120 Strongly Undecided I like80% your TV ads100% 0% 20% 40%Disagree 60% You have Agree a good selection of products Strongly Agreeare Undecided Disagree Employees friendly Agree I like your web site Stores are well-maintained Store hours are convenient Agree Undecid Store locations areStrongly convenient Agree 0% 5% 10% Disagree

Undecided

Agree

Strongly Agree

Disagree 21% 29% 31% 12% 43% 21% 38% 15% 25% 27%

Strongly Disagree 32% 14% 17% 8% 17% 12% 16% 12% 17% 41%

Chart Title Chart Title 10%

15%

20%

25% 30% Chart Title 35%

40%

45%

50%

your company , I am satisfied uality products 120% Undecided ke80% your TV ads100% %ee 20% 40%Disagree 60% Strongly 80% 100% 120% Disagree on of products greeare Undecided Disagree Strongly ees friendly Disagree e your web site well-maintained are convenient Strongly Agree Undecided Disagree Strongly are convenient Agree Disagree 0% 5% 10% 15% 20% 25% 30% 35% Strongly Agree

40%

45%

1/1/1959 2/1/1959 3/1/1959 4/1/1959 5/1/1959 6/1/1959 7/1/1959 8/1/1959 9/1/1959 10/1/1959 11/1/1959 12/1/1959 1/1/1960 2/1/1960 3/1/1960 4/1/1960 5/1/1960 6/1/1960 7/1/1960 8/1/1960 9/1/1960 10/1/1960 11/1/1960 12/1/1960 1/1/1961 2/1/1961 3/1/1961 4/1/1961 5/1/1961 6/1/1961 7/1/1961 8/1/1961 9/1/1961 10/1/1961 11/1/1961 12/1/1961 1/1/1962 2/1/1962 3/1/1962 4/1/1962 5/1/1962 6/1/1962

Housing starts 1,657,000 1,667,000 1,620,000 1,590,000 1,498,000 1,503,000 1,547,000 1,430,000 1,540,000 1,355,000 1,416,000 1,601,000 1,460,000 1,503,000 1,109,000 1,289,000 1,271,000 1,247,000 1,197,000 1,344,000 1,097,000 1,246,000 1,246,000 1,063,000 1,183,000 1,226,000 1,312,000 1,166,000 1,228,000 1,382,000 1,335,000 1,312,000 1,429,000 1,415,000 1,385,000 1,365,000 1,361,000 1,278,000 1,443,000 1,524,000 1,483,000 1,404,000

7/1/1962 8/1/1962 9/1/1962 10/1/1962 11/1/1962 12/1/1962 1/1/1963 2/1/1963 3/1/1963 4/1/1963 5/1/1963 6/1/1963 7/1/1963 8/1/1963 9/1/1963 10/1/1963 11/1/1963 12/1/1963 1/1/1964 2/1/1964 3/1/1964 4/1/1964 5/1/1964 6/1/1964 7/1/1964 8/1/1964 9/1/1964 10/1/1964 11/1/1964 12/1/1964 1/1/1965 2/1/1965 3/1/1965 4/1/1965 5/1/1965 6/1/1965 7/1/1965 8/1/1965 9/1/1965 10/1/1965 11/1/1965 12/1/1965 1/1/1966

1,450,000 1,517,000 1,324,000 1,533,000 1,622,000 1,564,000 1,244,000 1,456,000 1,534,000 1,689,000 1,641,000 1,588,000 1,614,000 1,639,000 1,763,000 1,779,000 1,622,000 1,491,000 1,603,000 1,820,000 1,517,000 1,448,000 1,467,000 1,550,000 1,562,000 1,569,000 1,455,000 1,524,000 1,486,000 1,484,000 1,361,000 1,433,000 1,423,000 1,438,000 1,478,000 1,488,000 1,529,000 1,432,000 1,482,000 1,452,000 1,460,000 1,656,000 1,370,000

2/1/1966 3/1/1966 4/1/1966 5/1/1966 6/1/1966 7/1/1966 8/1/1966 9/1/1966 10/1/1966 11/1/1966 12/1/1966 1/1/1967 2/1/1967 3/1/1967 4/1/1967 5/1/1967 6/1/1967 7/1/1967 8/1/1967 9/1/1967 10/1/1967 11/1/1967 12/1/1967 1/1/1968 2/1/1968 3/1/1968 4/1/1968 5/1/1968 6/1/1968 7/1/1968 8/1/1968 9/1/1968 10/1/1968 11/1/1968 12/1/1968 1/1/1969 2/1/1969 3/1/1969 4/1/1969 5/1/1969 6/1/1969 7/1/1969 8/1/1969

1,378,000 1,394,000 1,352,000 1,265,000 1,194,000 1,086,000 1,119,000 1,046,000 843,000 961,000 990,000 1,067,000 1,123,000 1,056,000 1,091,000 1,304,000 1,248,000 1,364,000 1,407,000 1,421,000 1,491,000 1,538,000 1,308,000 1,380,000 1,520,000 1,466,000 1,554,000 1,408,000 1,405,000 1,512,000 1,495,000 1,556,000 1,569,000 1,630,000 1,548,000 1,769,000 1,705,000 1,561,000 1,524,000 1,583,000 1,528,000 1,368,000 1,358,000

9/1/1969 10/1/1969 11/1/1969 12/1/1969 1/1/1970 2/1/1970 3/1/1970 4/1/1970 5/1/1970 6/1/1970 7/1/1970 8/1/1970 9/1/1970 10/1/1970 11/1/1970 12/1/1970 1/1/1971 2/1/1971 3/1/1971 4/1/1971 5/1/1971 6/1/1971 7/1/1971 8/1/1971 9/1/1971 10/1/1971 11/1/1971 12/1/1971 1/1/1972 2/1/1972 3/1/1972 4/1/1972 5/1/1972 6/1/1972 7/1/1972 8/1/1972 9/1/1972 10/1/1972 11/1/1972 12/1/1972 1/1/1973 2/1/1973 3/1/1973

1,507,000 1,381,000 1,229,000 1,327,000 1,085,000 1,305,000 1,319,000 1,264,000 1,290,000 1,385,000 1,517,000 1,399,000 1,534,000 1,580,000 1,647,000 1,893,000 1,828,000 1,741,000 1,910,000 1,986,000 2,049,000 2,026,000 2,083,000 2,158,000 2,041,000 2,128,000 2,182,000 2,295,000 2,494,000 2,390,000 2,334,000 2,249,000 2,221,000 2,254,000 2,252,000 2,382,000 2,481,000 2,485,000 2,421,000 2,366,000 2,481,000 2,289,000 2,365,000

4/1/1973 5/1/1973 6/1/1973 7/1/1973 8/1/1973 9/1/1973 10/1/1973 11/1/1973 12/1/1973 1/1/1974 2/1/1974 3/1/1974 4/1/1974 5/1/1974 6/1/1974 7/1/1974 8/1/1974 9/1/1974 10/1/1974 11/1/1974 12/1/1974 1/1/1975 2/1/1975 3/1/1975 4/1/1975 5/1/1975 6/1/1975 7/1/1975 8/1/1975 9/1/1975 10/1/1975 11/1/1975 12/1/1975 1/1/1976 2/1/1976 3/1/1976 4/1/1976 5/1/1976 6/1/1976 7/1/1976 8/1/1976 9/1/1976 10/1/1976

2,084,000 2,266,000 2,067,000 2,123,000 2,051,000 1,874,000 1,677,000 1,724,000 1,526,000 1,451,000 1,752,000 1,555,000 1,607,000 1,426,000 1,513,000 1,316,000 1,142,000 1,150,000 1,070,000 1,026,000 975,000 1,032,000 904,000 993,000 1,005,000 1,121,000 1,087,000 1,226,000 1,260,000 1,264,000 1,344,000 1,360,000 1,321,000 1,367,000 1,538,000 1,421,000 1,395,000 1,459,000 1,495,000 1,401,000 1,550,000 1,720,000 1,629,000

11/1/1976 12/1/1976 1/1/1977 2/1/1977 3/1/1977 4/1/1977 5/1/1977 6/1/1977 7/1/1977 8/1/1977 9/1/1977 10/1/1977 11/1/1977 12/1/1977 1/1/1978 2/1/1978 3/1/1978 4/1/1978 5/1/1978 6/1/1978 7/1/1978 8/1/1978 9/1/1978 10/1/1978 11/1/1978 12/1/1978 1/1/1979 2/1/1979 3/1/1979 4/1/1979 5/1/1979 6/1/1979 7/1/1979 8/1/1979 9/1/1979 10/1/1979 11/1/1979 12/1/1979 1/1/1980 2/1/1980 3/1/1980 4/1/1980 5/1/1980

1,641,000 1,804,000 1,527,000 1,943,000 2,063,000 1,892,000 1,971,000 1,893,000 2,058,000 2,020,000 1,949,000 2,042,000 2,042,000 2,142,000 1,718,000 1,738,000 2,032,000 2,197,000 2,075,000 2,070,000 2,092,000 1,996,000 1,970,000 1,981,000 2,094,000 2,044,000 1,630,000 1,520,000 1,847,000 1,748,000 1,876,000 1,913,000 1,760,000 1,778,000 1,832,000 1,681,000 1,524,000 1,498,000 1,341,000 1,350,000 1,047,000 1,051,000 927,000

6/1/1980 7/1/1980 8/1/1980 9/1/1980 10/1/1980 11/1/1980 12/1/1980 1/1/1981 2/1/1981 3/1/1981 4/1/1981 5/1/1981 6/1/1981 7/1/1981 8/1/1981 9/1/1981 10/1/1981 11/1/1981 12/1/1981 1/1/1982 2/1/1982 3/1/1982 4/1/1982 5/1/1982 6/1/1982 7/1/1982 8/1/1982 9/1/1982 10/1/1982 11/1/1982 12/1/1982 1/1/1983 2/1/1983 3/1/1983 4/1/1983 5/1/1983 6/1/1983 7/1/1983 8/1/1983 9/1/1983 10/1/1983 11/1/1983 12/1/1983

1,196,000 1,269,000 1,436,000 1,471,000 1,523,000 1,510,000 1,482,000 1,547,000 1,246,000 1,306,000 1,360,000 1,140,000 1,045,000 1,041,000 940,000 911,000 873,000 837,000 910,000 843,000 866,000 931,000 917,000 1,025,000 902,000 1,166,000 1,046,000 1,144,000 1,173,000 1,372,000 1,303,000 1,586,000 1,699,000 1,606,000 1,472,000 1,776,000 1,733,000 1,785,000 1,910,000 1,710,000 1,715,000 1,785,000 1,688,000

1/1/1984 2/1/1984 3/1/1984 4/1/1984 5/1/1984 6/1/1984 7/1/1984 8/1/1984 9/1/1984 10/1/1984 11/1/1984 12/1/1984 1/1/1985 2/1/1985 3/1/1985 4/1/1985 5/1/1985 6/1/1985 7/1/1985 8/1/1985 9/1/1985 10/1/1985 11/1/1985 12/1/1985 1/1/1986 2/1/1986 3/1/1986 4/1/1986 5/1/1986 6/1/1986 7/1/1986 8/1/1986 9/1/1986 10/1/1986 11/1/1986 12/1/1986 1/1/1987 2/1/1987 3/1/1987 4/1/1987 5/1/1987 6/1/1987 7/1/1987

1,897,000 2,260,000 1,663,000 1,851,000 1,774,000 1,843,000 1,732,000 1,586,000 1,698,000 1,590,000 1,689,000 1,612,000 1,711,000 1,632,000 1,800,000 1,821,000 1,680,000 1,676,000 1,684,000 1,743,000 1,676,000 1,834,000 1,698,000 1,942,000 1,972,000 1,848,000 1,876,000 1,933,000 1,854,000 1,847,000 1,782,000 1,807,000 1,687,000 1,681,000 1,623,000 1,833,000 1,774,000 1,784,000 1,726,000 1,614,000 1,628,000 1,594,000 1,575,000

8/1/1987 9/1/1987 10/1/1987 11/1/1987 12/1/1987 1/1/1988 2/1/1988 3/1/1988 4/1/1988 5/1/1988 6/1/1988 7/1/1988 8/1/1988 9/1/1988 10/1/1988 11/1/1988 12/1/1988 1/1/1989 2/1/1989 3/1/1989 4/1/1989 5/1/1989 6/1/1989 7/1/1989 8/1/1989 9/1/1989 10/1/1989 11/1/1989 12/1/1989 1/1/1990 2/1/1990 3/1/1990 4/1/1990 5/1/1990 6/1/1990 7/1/1990 8/1/1990 9/1/1990 10/1/1990 11/1/1990 12/1/1990 1/1/1991 2/1/1991

1,605,000 1,695,000 1,515,000 1,656,000 1,400,000 1,271,000 1,473,000 1,532,000 1,573,000 1,421,000 1,478,000 1,467,000 1,493,000 1,492,000 1,522,000 1,569,000 1,563,000 1,621,000 1,425,000 1,422,000 1,339,000 1,331,000 1,397,000 1,427,000 1,332,000 1,279,000 1,410,000 1,351,000 1,251,000 1,551,000 1,437,000 1,289,000 1,248,000 1,212,000 1,177,000 1,171,000 1,115,000 1,110,000 1,014,000 1,145,000 969,000 798,000 965,000

3/1/1991 4/1/1991 5/1/1991 6/1/1991 7/1/1991 8/1/1991 9/1/1991 10/1/1991 11/1/1991 12/1/1991 1/1/1992 2/1/1992 3/1/1992 4/1/1992 5/1/1992 6/1/1992 7/1/1992 8/1/1992 9/1/1992 10/1/1992 11/1/1992 12/1/1992 1/1/1993 2/1/1993 3/1/1993 4/1/1993 5/1/1993 6/1/1993 7/1/1993 8/1/1993 9/1/1993 10/1/1993 11/1/1993 12/1/1993 1/1/1994 2/1/1994 3/1/1994 4/1/1994 5/1/1994 6/1/1994 7/1/1994 8/1/1994 9/1/1994

921,000 1,001,000 996,000 1,036,000 1,063,000 1,049,000 1,015,000 1,079,000 1,103,000 1,079,000 1,176,000 1,250,000 1,297,000 1,099,000 1,214,000 1,145,000 1,139,000 1,226,000 1,186,000 1,244,000 1,214,000 1,227,000 1,210,000 1,210,000 1,083,000 1,258,000 1,260,000 1,280,000 1,254,000 1,300,000 1,343,000 1,392,000 1,376,000 1,533,000 1,272,000 1,337,000 1,564,000 1,465,000 1,526,000 1,409,000 1,439,000 1,450,000 1,474,000

10/1/1994 11/1/1994 12/1/1994 1/1/1995 2/1/1995 3/1/1995 4/1/1995 5/1/1995 6/1/1995 7/1/1995 8/1/1995 9/1/1995 10/1/1995 11/1/1995 12/1/1995 1/1/1996 2/1/1996 3/1/1996 4/1/1996 5/1/1996 6/1/1996 7/1/1996 8/1/1996 9/1/1996 10/1/1996 11/1/1996 12/1/1996 1/1/1997 2/1/1997 3/1/1997 4/1/1997 5/1/1997 6/1/1997 7/1/1997 8/1/1997 9/1/1997 10/1/1997 11/1/1997 12/1/1997 1/1/1998 2/1/1998 3/1/1998 4/1/1998

1,450,000 1,511,000 1,455,000 1,407,000 1,316,000 1,249,000 1,267,000 1,314,000 1,281,000 1,461,000 1,416,000 1,369,000 1,369,000 1,452,000 1,431,000 1,467,000 1,491,000 1,424,000 1,516,000 1,504,000 1,467,000 1,472,000 1,557,000 1,475,000 1,392,000 1,489,000 1,370,000 1,355,000 1,486,000 1,457,000 1,492,000 1,442,000 1,494,000 1,437,000 1,390,000 1,546,000 1,520,000 1,510,000 1,566,000 1,525,000 1,584,000 1,567,000 1,540,000

5/1/1998 6/1/1998 7/1/1998 8/1/1998 9/1/1998 10/1/1998 11/1/1998 12/1/1998 1/1/1999 2/1/1999 3/1/1999 4/1/1999 5/1/1999 6/1/1999 7/1/1999 8/1/1999 9/1/1999 10/1/1999 11/1/1999 12/1/1999 1/1/2000 2/1/2000 3/1/2000 4/1/2000 5/1/2000 6/1/2000 7/1/2000 8/1/2000 9/1/2000 10/1/2000 11/1/2000 12/1/2000 1/1/2001 2/1/2001 3/1/2001 4/1/2001 5/1/2001 6/1/2001 7/1/2001 8/1/2001 9/1/2001 10/1/2001 11/1/2001

1,536,000 1,641,000 1,698,000 1,614,000 1,582,000 1,715,000 1,660,000 1,792,000 1,748,000 1,670,000 1,710,000 1,553,000 1,611,000 1,559,000 1,669,000 1,648,000 1,635,000 1,608,000 1,648,000 1,708,000 1,636,000 1,737,000 1,604,000 1,626,000 1,575,000 1,559,000 1,463,000 1,541,000 1,507,000 1,549,000 1,551,000 1,532,000 1,600,000 1,625,000 1,590,000 1,649,000 1,605,000 1,636,000 1,670,000 1,567,000 1,562,000 1,540,000 1,602,000

12/1/2001 1/1/2002 2/1/2002 3/1/2002 4/1/2002 5/1/2002 6/1/2002 7/1/2002 8/1/2002 9/1/2002 10/1/2002 11/1/2002 12/1/2002 1/1/2003 2/1/2003 3/1/2003 4/1/2003 5/1/2003 6/1/2003 7/1/2003 8/1/2003 9/1/2003 10/1/2003 11/1/2003 12/1/2003 1/1/2004 2/1/2004 3/1/2004 4/1/2004 5/1/2004 6/1/2004 7/1/2004 8/1/2004 9/1/2004 10/1/2004 11/1/2004 12/1/2004 1/1/2005 2/1/2005 3/1/2005 4/1/2005 5/1/2005 6/1/2005

1,568,000 1,698,000 1,829,000 1,642,000 1,592,000 1,764,000 1,717,000 1,655,000 1,633,000 1,804,000 1,648,000 1,753,000 1,788,000 1,853,000 1,629,000 1,726,000 1,643,000 1,751,000 1,867,000 1,897,000 1,833,000 1,939,000 1,967,000 2,083,000 2,057,000 1,911,000 1,846,000 1,998,000 2,003,000 1,981,000 1,828,000 2,002,000 2,024,000 1,905,000 2,072,000 1,782,000 2,042,000 2,144,000 2,207,000 1,864,000 2,061,000 2,025,000 2,068,000

7/1/2005 8/1/2005 9/1/2005 10/1/2005 11/1/2005 12/1/2005 1/1/2006 2/1/2006 3/1/2006 4/1/2006 5/1/2006 6/1/2006 7/1/2006 8/1/2006 9/1/2006 10/1/2006 11/1/2006 12/1/2006 1/1/2007 2/1/2007 3/1/2007 4/1/2007 5/1/2007 6/1/2007 7/1/2007 8/1/2007 9/1/2007 10/1/2007 11/1/2007 12/1/2007 1/1/2008 2/1/2008 3/1/2008 4/1/2008 5/1/2008 6/1/2008 7/1/2008 8/1/2008 9/1/2008 10/1/2008 11/1/2008 12/1/2008 1/1/2009

2,054,000 2,095,000 2,151,000 2,065,000 2,147,000 1,994,000 2,273,000 2,119,000 1,969,000 1,821,000 1,942,000 1,802,000 1,737,000 1,650,000 1,720,000 1,491,000 1,570,000 1,649,000 1,409,000 1,480,000 1,495,000 1,490,000 1,415,000 1,448,000 1,354,000 1,330,000 1,183,000 1,264,000 1,197,000 1,037,000 1,084,000 1,103,000 1,005,000 1,013,000 973,000 1,046,000 923,000 844,000 820,000 777,000 652,000 560,000 490,000

Housing starts 3,000,000

2/1/2009 3/1/2009 4/1/2009 5/1/2009 6/1/2009 7/1/2009 8/1/2009 9/1/2009 10/1/2009 11/1/2009 12/1/2009 1/1/2010 2/1/2010 3/1/2010 4/1/2010 5/1/2010 6/1/2010 7/1/2010 8/1/2010 9/1/2010 10/1/2010 11/1/2010 12/1/2010 1/1/2011 2/1/2011 3/1/2011 4/1/2011 5/1/2011 6/1/2011 7/1/2011 8/1/2011 9/1/2011 10/1/2011 11/1/2011 12/1/2011

582,000 505,000 478,000 540,000 585,000 594,000 586,000 585,000 534,000 588,000 581,000 615,000 603,000 626,000 687,000 580,000 539,000 550,000 606,000 597,000 539,000 551,000 526,000 636,000 518,000 593,000 549,000 553,000 615,000 615,000 585,000 646,000 628,000 685,000 657,000

Housing starts 3,000,000

2,500,000

2,000,000

1,500,000

1,000,000

500,000

1/1/1959

1/1/1967

1/1/1975

1/1/1983

1/1/199

using starts

using starts

1975

1/1/1983

1/1/1991

1/1/1999

1/1/2007

See appendix FFRDCs = Federally tables Funded and 4-6. Research and Development Centers Employees by 4-5 Region NOTE: Data Science & Engineering labels rounded Indicators to nearest – 2002 whole number. National R&D expenditures are an estimated $265 billion in 2000. West Mid East See appendix tables 4-3, 4-5, 4-7, 4-11, and 4-15.

2009 108 Science & Engineering Indicators – 2002 2010 121 2011 136 32 2012 208 87 2013 312 90

201 222 183 143 140

Chart Title 350 300 250 200 150 100 50 0 2009

2010

2011 West

Mid

East

Chart Title

2011 West

Mid

2012 East

2013

Population Projections (in thousands) California Oregon Washington 1995 31,589 3,141 5,431 2000 32,521 3,397 5,858 2005 34,441 3,613 6,258 2015 41,373 3,992 7,058 2025 49,285 4,349 7,808

Chart Title 50,000 40,000 30,000 20,000 10,000 0 1995

2000

2005

California

Oregon

2015 Washington

20

Chart Title

Washington Oregon 2005

ornia

Oregon

2015 Washington

California 2025

Version Excel 2013 Excel 2010 Excel 2007 Excel 2003

Number of users 183 981 612 283

Number of users 183 283

612

Excel 2013

Excel 2010

981

Excel 2007

Exc

mber of users 183 283

612

xcel 2010

981

Excel 2007

Excel 2003

Category Rent Supplies Utilities Region 1 Salary Region 2 Salary Region 3 Salary Region 4 Salary

Amount 12,909,288 3,221,904 2,981,448 7,832,288 1,959,768 3,983,233 2,887,309

XY Chart 1 Year Month 2011 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2012 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Calls 904 895 896 881 909 864 907 893 875 911 922 840 909 897 885 856 825 815 799 813 788 777 786 798

Sales 89 89 89 86 92 86 91 91 86 88 93 91 91 89 87 82 81 77 76 85 76 75 77 97

Chart Title 1000 800 600 Axis Title

400 200 0

0

5

10

15 Axis Title

Calls

Page 65

Sales

5

XY Chart 1

Chart Title

10

15

20

25

30

Axis Title Calls

Sales

Page 66

Press F9 for a new chart

a 1.0 6.2 11.4 16.6 21.8 27.0 32.2 37.4 42.6 47.8 53.0 58.2 63.4 68.6 73.8 79.0 84.2 89.4 94.6 99.8 105.0 110.2 115.4 120.6 125.8 131.0 136.2 141.4 146.6 151.8 157.0 162.2 167.4 172.6 177.8 183.0 188.2 193.4 198.6 203.8 209.0 214.2 219.4 224.6 229.8

b 1.0 3.0 0.6 -1.8 -4.2 -6.6 -9.0 -11.4 -13.8 -16.2 -18.6 -21.0 -23.4 -25.8 -28.2 -30.6 -33.0 -35.4 -37.8 -40.2 -42.6 -45.0 -47.4 -49.8 -52.2 -54.6 -57.0 -59.4 -61.8 -64.2 -66.6 -69.0 -71.4 -73.8 -76.2 -78.6 -81.0 -83.4 -85.8 -88.2 -90.6 -93.0 -95.4 -97.8 -100.2

a_inc: b_inc: t_inc:

t 0.0 -1.5 -3.0 -4.5 -6.0 -7.5 -9.0 -10.5 -12.0 -13.5 -15.0 -16.5 -18.0 -19.5 -21.0 -22.5 -24.0 -25.5 -27.0 -28.5 -30.0 -31.5 -33.0 -34.5 -36.0 -37.5 -39.0 -40.5 -42.0 -43.5 -45.0 -46.5 -48.0 -49.5 -51.0 -52.5 -54.0 -55.5 -57.0 -58.5 -60.0 -61.5 -63.0 -64.5 -66.0

5.20 -2.40 -1.50

x

y

1.0 0.1 -11.2 -3.1 21.4 5.8 -29.1 -29.7 42.9 54.2 -61.3 -72.9 73.7 91.0 -79.8 -109.8 79.9 129.0 -74.5 -148.1 63.8 166.0 -48.2 -181.9 28.0 194.8 -3.8 -203.9 -23.6 208.6 53.5 -208.0 -85.0 201.9 117.0 -189.9 -148.5 171.9 178.3 -148.0 -205.4 118.6 228.6 -84.0 -246.9

0.0 -0.2 -1.9 19.6 5.0 -28.5 -20.1 52.3 17.3 -50.2 -29.3 44.5 48.5 -36.8 -70.4 26.2 92.9 -11.7 -114.6 -7.2 134.4 30.5 -151.3 -58.2 164.3 89.8 -172.5 -124.7 175.2 162.0 -171.6 -201.0 161.2 240.4 -143.8 -279.2 119.2 316.1 -87.4 -349.9 48.7 379.4 -3.5 -403.3 -47.4

235.0 240.2 245.4 250.6 255.8 261.0 266.2 271.4 276.6 281.8 287.0 292.2 297.4 302.6 307.8 313.0 318.2 323.4 328.6 333.8 339.0 344.2 349.4 354.6 359.8 365.0 370.2 375.4 380.6 385.8 391.0 396.2 401.4 406.6 411.8 417.0 422.2 427.4 432.6 437.8 443.0 448.2 453.4 458.6 463.8 469.0 474.2 479.4 484.6 489.8

-102.6 -105.0 -107.4 -109.8 -112.2 -114.6 -117.0 -119.4 -121.8 -124.2 -126.6 -129.0 -131.4 -133.8 -136.2 -138.6 -141.0 -143.4 -145.8 -148.2 -150.6 -153.0 -155.4 -157.8 -160.2 -162.6 -165.0 -167.4 -169.8 -172.2 -174.6 -177.0 -179.4 -181.8 -184.2 -186.6 -189.0 -191.4 -193.8 -196.2 -198.6 -201.0 -203.4 -205.8 -208.2 -210.6 -213.0 -215.4 -217.8 -220.2

-67.5 -69.0 -70.5 -72.0 -73.5 -75.0 -76.5 -78.0 -79.5 -81.0 -82.5 -84.0 -85.5 -87.0 -88.5 -90.0 -91.5 -93.0 -94.5 -96.0 -97.5 -99.0 -100.5 -102.0 -103.5 -105.0 -106.5 -108.0 -109.5 -111.0 -112.5 -114.0 -115.5 -117.0 -118.5 -120.0 -121.5 -123.0 -124.5 -126.0 -127.5 -129.0 -130.5 -132.0 -133.5 -135.0 -136.5 -138.0 -139.5 -141.0

44.9 259.4 -2.3 -265.2 -42.9 263.7 89.5 -254.4 -136.3 237.0 181.9 -211.5 -224.9 178.0 264.0 -136.9 -297.7 88.7 324.8 -34.5 -344.1 -24.8 354.5 87.9 -355.1 -153.3 345.4 219.5 -324.7 -284.9 293.1 347.6 -250.5 -405.9 197.3 457.9 -134.1 -502.1 62.0 536.8 17.9 -560.6 -104.1 572.1 195.1 -570.4 -288.8 554.7 383.3 -524.4

420.6 103.3 -430.3 -162.9 431.5 225.2 -423.6 -288.8 406.1 352.2 -378.7 -413.8 341.5 472.3 -294.7 -525.9 238.8 573.2 -174.4 -612.7 102.7 643.2 -24.7 -663.4 -58.2 672.5 144.3 -669.7 -232.1 654.6 319.6 -626.8 -404.9 586.5 486.3 -534.0 -561.8 470.0 629.7 -395.5 -688.1 311.5 735.6 -219.7 -770.8 121.6 792.7 -19.2 -800.3 -85.5

495.0 500.2 505.4 510.6 515.8 521.0 526.2 531.4 536.6 541.8 547.0 552.2 557.4 562.6 567.8 573.0 578.2 583.4 588.6 593.8 599.0 604.2 609.4 614.6 619.8 625.0 630.2 635.4 640.6 645.8 651.0 656.2 661.4 666.6 671.8 677.0 682.2 687.4 692.6 697.8 703.0 708.2 713.4 718.6 723.8 729.0 734.2 739.4 744.6 749.8

-222.6 -225.0 -227.4 -229.8 -232.2 -234.6 -237.0 -239.4 -241.8 -244.2 -246.6 -249.0 -251.4 -253.8 -256.2 -258.6 -261.0 -263.4 -265.8 -268.2 -270.6 -273.0 -275.4 -277.8 -280.2 -282.6 -285.0 -287.4 -289.8 -292.2 -294.6 -297.0 -299.4 -301.8 -304.2 -306.6 -309.0 -311.4 -313.8 -316.2 -318.6 -321.0 -323.4 -325.8 -328.2 -330.6 -333.0 -335.4 -337.8 -340.2

-142.5 -144.0 -145.5 -147.0 -148.5 -150.0 -151.5 -153.0 -154.5 -156.0 -157.5 -159.0 -160.5 -162.0 -163.5 -165.0 -166.5 -168.0 -169.5 -171.0 -172.5 -174.0 -175.5 -177.0 -178.5 -180.0 -181.5 -183.0 -184.5 -186.0 -187.5 -189.0 -190.5 -192.0 -193.5 -195.0 -196.5 -198.0 -199.5 -201.0 -202.5 -204.0 -205.5 -207.0 -208.5 -210.0 -211.5 -213.0 -214.5 -216.0

-476.4 479.5 565.9 -420.1 -649.6 346.7 725.3 -260.1 -790.7 161.5 844.0 -52.4 -883.3 -65.4 907.0 189.8 -913.8 -318.6 902.7 449.2 -873.0 -579.1 824.6 705.4 -757.4 -825.6 672.0 936.8 -569.3 -1,036.4 450.7 1,121.9 -317.8 -1,191.1 172.7 1,242.0 -17.8 -1,272.8 -144.3 1,282.2 310.6 -1,269.3 -478.2 1,233.5 643.8 -1,174.7 -804.2 1,093.5 956.1 -990.6

793.2 190.4 -771.0 -293.2 734.0 391.7 -682.5 -483.7 617.3 567.2 -539.6 -640.0 450.7 700.4 -352.3 -747.0 246.4 778.3 -135.2 -793.4 21.1 791.8 93.5 -773.0 -206.1 737.3 314.0 -685.2 -414.7 617.5 505.8 -535.5 -585.0 440.8 650.4 -335.4 -700.0 221.5 732.5 -101.6 -746.7 -21.6 741.8 145.2 -717.7 -266.3 674.3 382.1 -612.3 -489.5

755.0 760.2 765.4 770.6 775.8 781.0 786.2 791.4 796.6 801.8 807.0 812.2 817.4 822.6 827.8 833.0 838.2 843.4 848.6 853.8 859.0 864.2 869.4 874.6 879.8 885.0 890.2 895.4 900.6 905.8 911.0 916.2 921.4 926.6 931.8 937.0 942.2 947.4 952.6 957.8 963.0 968.2 973.4 978.6 983.8 989.0 994.2 999.4 1,004.6 1,009.8

-342.6 -345.0 -347.4 -349.8 -352.2 -354.6 -357.0 -359.4 -361.8 -364.2 -366.6 -369.0 -371.4 -373.8 -376.2 -378.6 -381.0 -383.4 -385.8 -388.2 -390.6 -393.0 -395.4 -397.8 -400.2 -402.6 -405.0 -407.4 -409.8 -412.2 -414.6 -417.0 -419.4 -421.8 -424.2 -426.6 -429.0 -431.4 -433.8 -436.2 -438.6 -441.0 -443.4 -445.8 -448.2 -450.6 -453.0 -455.4 -457.8 -460.2

-217.5 -219.0 -220.5 -222.0 -223.5 -225.0 -226.5 -228.0 -229.5 -231.0 -232.5 -234.0 -235.5 -237.0 -238.5 -240.0 -241.5 -243.0 -244.5 -246.0 -247.5 -249.0 -250.5 -252.0 -253.5 -255.0 -256.5 -258.0 -259.5 -261.0 -262.5 -264.0 -265.5 -267.0 -268.5 -270.0 -271.5 -273.0 -274.5 -276.0 -277.5 -279.0 -280.5 -282.0 -283.5 -285.0 -286.5 -288.0 -289.5 -291.0

-1,096.5 867.3 1,222.2 -725.5 -1,330.6 567.2 1,419.1 -395.2 -1,485.6 212.3 1,528.2 -21.7 -1,545.8 -173.2 1,537.3 368.7 -1,502.5 -561.3 1,441.5 747.2 -1,355.0 -922.9 1,244.3 1,084.7 -1,111.0 -1,229.5 957.4 1,354.3 -786.0 -1,456.5 600.1 1,533.8 -402.9 -1,584.6 198.1 1,607.5 10.3 -1,601.9 -218.5 1,567.6 422.2 -1,505.2 -617.6 1,415.7 800.8 -1,300.7 -967.9 1,162.4 1,115.7 -1,003.3

532.7 585.8 -436.9 -668.4 326.8 735.0 -204.5 -783.4 72.7 812.0 65.8 -819.4 -207.9 804.8 350.4 -767.8 -489.8 708.5 622.9 -627.4 -746.2 525.8 856.5 -405.1 -950.8 267.5 1,026.3 -115.4 -1,080.5 -48.1 1,111.4 220.0 -1,117.3 -396.6 1,097.2 574.2 -1,050.4 -749.0 976.9 917.0 -877.4 -1,074.2 752.8 1,216.9 -604.8 -1,341.6 435.8 1,444.7 -248.4 -1,523.5

2,000

1,500

1,000

500 -2,000.0

-1,500.0

-1,000.0

-500.0

0

-500

-1,000

-1,500

-2,000

1,015.0 1,020.2 1,025.4 1,030.6 1,035.8

-462.6 -465.0 -467.4 -469.8 -472.2

-292.5 -294.0 -295.5 -297.0 -298.5

-1,241.1 826.7 1,341.5 -636.0 -1,414.7

45.9 1,575.2 168.2 -1,597.8 -389.8

00.0

y 2,000.0 1,500.0 1,000.0 500.0 -1,000.0

-500.0

0.0 0.0 -500.0

-1,000.0 -1,500.0 -2,000.0

500.0

1,000.0

1,500.0

2,000.0

Product A

Qtr-1 Qtr-2 Qtr-3 Qtr-4

474 732 897 977

Product B

1,243 902 621 1,345

Product C

564 455 233 565

1,600

Chart

1,400 1,200 1,000 800 600

Chart Title

400 200 0 Qtr-1

Qtr-2

Qtr

1,500 1,000

Product C

Product B

Product

500 0 Qtr-1

Qtr-2 Product A

Qtr-3 Product B

Pr

Chart Title

Chart Title

Qtr-2

duct C

Qtr-3

Product B

Qtr-4

Product A

Product C Product B Qtr-2

roduct A

Qtr-3 Product B

Product A Product C Qtr-4

Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Snow Ski Sales 6,897 7,732 4,500 3,122 893 734 891 559 5,433 8,734 11,873 18,730

Water Ski Sales 1,983 5,547 7,330 9,832 10,739 16,453 15,874 9,833 3,244 2,873 3,459 5,433

Chart Title 20,000 15,000 10,000 5,000 -

Stacked Bar Charts

Jan Feb Mar Apr May Jun

Jul

Snow Ski Sales

Aug Sep Oct No Water Ski Sales

Chart Title

ay Jun

Jul Aug Sep Oct Nov Dec

Ski Sales

Water Ski Sales

Red Color-1 Color-2 Color-3 Color-4

128 115 128 149

Green 255 173 128 39

Blue 64 122 128 239

Chart Title Column B

Column C

Color-1

Colum

Color-1 1 400 400 200

Color-4

200 0

Color-2

0

Color-3 3

2

nB

Chart Title Column C

Color-1

Column D

Color-1 1 400 400 200 200 0

Color-2

0

Color-3 2

100.00 100.30 100.60 100.90 101.20 101.50 101.80 102.10 102.40 102.70 103.00 103.30

0.00 -0.506 -0.229 0.069 0.361 0.620 0.824 0.955 1.000 0.956 0.826 0.623 0.364

0.30 -0.211 0.067 0.365 0.656 0.916 1.120 1.250 1.296 1.251 1.122 0.919 0.660

0.60 0.058 0.336 0.634 0.925 1.185 1.389 1.519 1.565 1.520 1.391 1.188 0.929

0.90 0.277 0.554 0.852 1.144 1.404 1.608 1.738 1.783 1.739 1.610 1.406 1.147

1.20 0.426 0.703 1.001 1.293 1.552 1.756 1.887 1.932 1.888 1.758 1.555 1.296

C

2.000 1.000 0.000 -1.000

100.00

100.30

1

101.80

102.10

1

1.50 0.491 0.769 1.066 1.358 1.618 1.822 1.952 1.997 1.953 1.824 1.620 1.361

1.80 0.467 0.745 1.043 1.335 1.594 1.798 1.929 1.974 1.930 1.800 1.597 1.338

2.10 0.357 0.634 0.932 1.224 1.483 1.688 1.818 1.863 1.819 1.690 1.486 1.227

2.40 0.169 0.447 0.744 1.036 1.296 1.500 1.630 1.675 1.631 1.502 1.298 1.039

Chart Title

2.000 1.000 0.000 -1.000

100.00

100.30

100.60

100.90

101.20

101.50

101.80

102.10

102.40

102.70

103.00

103.30

2.70 -0.079 0.198 0.496 0.788 1.048 1.252 1.382 1.427 1.383 1.254 1.050 0.791

3.00 -0.365 -0.088 0.210 0.502 0.761 0.965 1.096 1.141 1.097 0.967 0.764 0.505

3.30 -0.664 -0.387 -0.089 0.203 0.462 0.667 0.797 0.842 0.798 0.669 0.465 0.206

3.60 -0.949 -0.671 -0.374 -0.082 0.178 0.382 0.512 0.557 0.513 0.384 0.180 -0.079

Participant Ray Pat Jill George Kevin Joe Cindy Terry

Original Weeks in Wieight Program 285 12 442 3 240 5 275 18 290 1 380 18 188 13 301 7

Weight Loss 37 20 28 43 2 15 13 32

Part Right Ear Left Ear Head Left Eye Right Eye Left Pupil Right Pupil Nose Mouth

X

Y 5.6 2.4 4.0 3.4 4.6 3.2 4.4 4.0 4.0

7.0 7.0 4.4 5.4 5.4 5.6 5.6 4.3 3.0

Bubble 35.0 35.0 60.0 18.0 18.0 5.0 5.0 11.0 10.0

Chart Title 10.0 9.0 8.0 7.0 6.0 5.0 4.0 3.0 2.0 1.0

0

1

2

3

4

5 X

Bubble

6

7

Chart Title

4

5 X

Bubble

6

7

8

9

10

7/24 7/25 7/26 7/27 7/28

Volume 12,155 14,555 11,983 14,877 16,983

Open 69.81 70.94 74.75 74.88 76.09

High 72.63 74.00 75.75 75.31 76.38

Low 69.69 70.72 73.38 74.13 73.50

Close 70.50 73.25 75.63 75.25 74.94

18,000

Chart Title

16,000 14,000 12,000 10,000 8,000 6,000 4,000 2,000 0 7/24

7/25

7/26

Chart Title 18,000

High

16,000

7

7

14,000 12,000

7

10,000

7

8,000

7

6,000 4,000

6

2,000 0

6 7/24

7/25

7/26 Volume

Low

7/27

7/28

Chart Title

7/25

7/26

7/27

e High

78.00 76.00 74.00 72.00 70.00 68.00 66.00

Low

7/27

7/28

7/28

May Temperature Data High 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Low 74 70 72 66 61 59 73 72 70 73 79 82 75 71 70 70 68 69 73 71 72 80 84 78 81 80 75 74 70 72 71

Average 50 62 52 61 56 64 50 58 53 57 48 53.5 51 62 53 62.5 56 63 60 66.5 60 69.5 62 72 60 67.5 57 64 55 62.5 56 63 56 62 57 63 58 65.5 62 66.5 64 68 66 73 62 73 66 72 64 72.5 64 72 64 69.5 65 69.5 63 66.5 60 66 62 66.5

Chart Title 90 80 70 60 50 40 30 20 10 0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 2 Average

art Title

4 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Average

in work use line column pie

and column