Exercise Visualization Using Charts

Welcome to Session 16
A Chart is a tool one can use to communicate data graphically. It allows users
ti more easily see the meaning behind the numbers in the spreadsheet.
Charts make it easy to see
comparisions
patterns
trends
Let's go >
on 16
It allows users
eadsheet.
Let's go >
Salesperson January February March
Doe, Jane $ 765.00 $ 575.00 $ 350.00
Haveria, Luiz $ 605.00 $ 2,755.00 $ 1,265.00
Hines, Zach $ 500.00 $ 350.00 $ 235.00
Read, Tira $ 2,750.00 $ 550.00 $ 425.00
Smith, Bob $ 925.00 $ 3,330.00 $ 1,850.00
Stuart, Jill $ 400.00 $ 965.00 $ 125.00
Tall, Liz $ 1,655.00 $ 985.00 $ 425.00
Temple, Cheryl $ 1,140.00 $ 1,720.00 $ 300.00
Month Widgets Sprockets
Jan 40,983 64,983
Feb 36,732 68,981
Mar 49,831 77,398
Apr 33,323 80,000
May 39,879 65,000
Strongly Strongly
Item Agree Agree Undecided Disagree Disagree
Store locations are convenient 12% 14% 21% 21% 32%
Store hours are convenient 15% 18% 24% 29% 14%
Stores are well-maintained 9% 11% 32% 31% 17%
I like your web site 18% 32% 32% 12% 8%
Employees are friendly 2% 6% 32% 43% 17%
You have a good selection of products 16% 19% 32% 21% 12%
I like your TV ads 5% 9% 32% 38% 16%
You sell quality products 24% 21% 28% 15% 12%
Overall, I am satisfied 6% 28% 24% 25% 17%
I would recommend your company 3% 9% 20% 27% 41%
Daily Sales
19,874
19,382
20,064
21,026
22,178
22,110
21,926
21,405
21,733
21,267
21,523
21,865
21,210
21,402
21,610
20,699
20,962
20,195
19,592
19,699
19,617
18,599
17,482
17,549
17,970
18,618
19,194
19,712
20,450
19,462
20,677
20,834
21,339
21,507
21,133
21,636
21,659
22,234
22,504
21,902
21,995
21,723
22,008
21,666
21,771
22,970
23,236
22,983
22,183
21,757
22,039
22,175
22,882
23,183
22,461
22,578
22,404
21,828
21,853
22,140
21,887
21,369
21,087
20,306
20,257
19,996
19,609
19,422
20,001
19,937
20,368
20,959
21,809
21,795
23,145
23,696
23,666
23,841
24,322
25,073
24,808
24,869
24,719
24,457
24,651
24,926
24,115
24,136
23,485
23,360
24,140
23,947
24,082
24,710
24,622
23,995
23,638
23,979
23,811
23,884
22,972
23,540
22,653
21,582
21,226
21,373
22,002
22,255
23,268
24,315
23,682
23,255
23,936
24,438
24,363
25,360
24,413
23,838
24,318
24,648
24,046
24,021
22,947
23,091
23,234
23,312
23,887
23,262
22,572
22,897
23,649
23,739
22,971
23,374
22,803
23,751
23,748
23,797
23,616
23,690
23,135
23,936
24,380
24,324
25,172
25,391
25,367
25,179
26,059
26,488
26,426
26,680
27,149
26,751
26,760
27,197
27,497
27,661
27,878
27,852
27,961
27,739
28,042
27,169
27,454
27,816
28,648
28,506
28,415
29,268
30,140
29,526
29,591
29,379
30,310
30,351
31,715
31,739
31,832
32,722
33,254
32,302
31,571
30,969
30,846
32,098
32,189
32,954
33,919
33,670
33,055
34,396
35,099
34,064
34,643
34,811
34,165
34,477
33,914
33,837
National R&D expenditures, by source of funds: 1953–2000
Industry Federal Other

1953 43.5% 53.9% 2.5%
1954 42.3% 55.2% 2.6%
1955 40.2% 57.4% 2.5%
1956 39.4% 58.6% 2.1%
1957 35.0% 62.9% 2.1%
1958 34.0% 63.9% 2.1%
1959 32.5% 65.4% 2.1%
1960 32.9% 65.0% 2.0%
1961 32.7% 65.1% 2.2%
1962 32.8% 64.8% 2.4%
1963 31.1% 66.5% 2.4%
1964 30.8% 66.8% 2.4%
1965 32.3% 65.2% 2.5%
1966 33.2% 64.2% 2.6%
1967 34.9% 62.4% 2.7%
1968 36.5% 60.7% 2.8%
1969 38.5% 58.6% 2.9%
1970 39.8% 57.0% 3.2%
1971 40.2% 56.4% 3.4%
1972 40.8% 55.8% 3.4%
1973 43.0% 53.6% 3.4%
1974 44.6% 51.8% 3.6%
1975 44.4% 52.0% 3.7%
1976 44.9% 51.5% 3.7%
1977 45.2% 51.0% 3.7%
1978 46.0% 50.2% 3.8%
1979 47.1% 49.2% 3.7%
1980 48.9% 47.5% 3.7%
1981 49.7% 46.7% 3.6%
1982 50.3% 46.1% 3.6%
1983 50.3% 46.2% 3.6%
1984 51.0% 45.5% 3.5%
1985 50.5% 46.0% 3.5%
1986 50.7% 45.5% 3.9%
1987 49.6% 46.4% 4.1%
1988 50.8% 44.9% 4.3%
1989 52.8% 42.6% 4.6%
1990 54.7% 40.6% 4.7%
1991 57.4% 37.8% 4.8%
1992 58.2% 36.8% 5.0%
1993 58.3% 36.5% 5.2%
1994 58.6% 35.9% 5.5%
1995 60.4% 34.3% 5.3%
1996 62.5% 32.1% 5.3%
1997 64.2% 30.5% 5.4%
1998 65.2% 29.5% 5.4%
1999 66.9% 27.7% 5.3%
2000 68.4% 26.3% 5.3%
Version Number of users
Excel 2007 189
Excel 2003 1082
Excel 2002 612
Older version 373
Category Amount
Rent 12,909,288
Supplies 3,221,904
Utilities 2,981,448
Region 1 Salary 7,832,288
Product AProduct BProduct C
Qtr-1 474 1,243 564
Qtr-2 732 902 455
Qtr-3 897 621 233
Qtr-4 977 1,345 565
Year Month Calls Sales
2005 Jan 904 89
Feb 895 89
Mar 896 89
Apr 881 86
May 909 92
Jun 864 86
Jul 907 91
Aug 893 91
Sep 875 86
Oct 911 88
Nov 922 93
Dec 840 91
2006 Jan 909 91
Feb 897 89
Mar 885 87
Apr 856 82
May 825 81
Jun 815 77
Jul 799 76
Aug 813 85
Sep 788 76
Oct 777 75
Nov 786 77
Dec 798 97
A B C D E F G H
1
2
3
4
5 Actual Target
6 January 1331 1417
7 February 1606 1457
8 March 1624 1488
9 April 1225 992
10 May 1202 1339
11 June 1618 1334
12 July 909 930
A B C D E F
1
2
3
4 Secondary Axis
5
6
7 Units Revenue
8 January 55 $ 269,885.00
9 February 65 $ 330,915.00
10 March 88 $ 436,216.00
11 April 89 $ 450,073.00
12 May 65 $ 326,430.00
13 June 78 $ 394,524.00
14 July 87 $ 436,479.00
15 August 57 $ 280,554.00
16 September 62 $ 303,800.00

Exercise Visualization Using Charts

Uploaded by

Copyright:

Available Formats

Exercise Visualization Using Charts

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Exercise Visualization Using Charts

Uploaded by

Copyright:

Available Formats

Welcome to Session 16

Industry Federal Other

You might also like