|
|
Search
Contextures Sites
|
||
Excel Sample Data |
|
|
Below is the sample Excel data table used for many of my newsgroup and web site examples. It's sales data for an imaginary stationery company, and shows when the order was placed, which region the sale was made in, the sales representative, the item sold and the number of units sold. It also shows the cost of a single unit, and calculates the total cost of the order. You can select the sample Excel data in the table below, and copy it for use in your own tests. Or download the sample data in an Excel file, by clicking the link below. Download the zipped Excel sample data workbook Sample ChartAnd here's a pie chart that Dick Kusleika made from this data, using the online charting tool - Widgenie. I created a line chart from the sample Excel data, and you can see it on the same page. |
|
|
|
|
||
|
OrderDate
|
Region | Rep | Item |
Units
|
Cost
|
Total
|
|
1/6/09
|
Quebec | Jones | Pencil |
95
|
1.99
|
189.05
|
|
1/23/09
|
Ontario | Kivell | Binder |
50
|
19.99
|
999.50
|
|
2/9/09
|
Ontario | Jardine | Pencil |
36
|
4.99
|
179.64
|
|
2/26/09
|
Ontario | Gill | Pen |
27
|
19.99
|
539.73
|
|
3/15/09
|
Alberta | Sorvino | Pencil |
56
|
2.99
|
167.44
|
|
4/1/09
|
Quebec | Jones | Binder |
60
|
4.99
|
299.40
|
|
4/18/09
|
Ontario | Andrews | Pencil |
75
|
1.99
|
149.25
|
|
5/5/09
|
Ontario | Jardine | Pencil |
90
|
4.99
|
449.10
|
|
5/22/09
|
Alberta | Thompson | Pencil |
32
|
1.99
|
63.68
|
|
6/8/09
|
Quebec | Jones | Binder |
60
|
8.99
|
539.40
|
|
6/25/09
|
Ontario | Morgan | Pencil |
90
|
4.99
|
449.10
|
|
7/12/09
|
Quebec | Howard | Binder |
29
|
1.99
|
57.71
|
|
7/29/09
|
Quebec | Parent | Binder |
81
|
19.99
|
1,619.19
|
|
8/15/09
|
Quebec | Jones | Pencil |
35
|
4.99
|
174.65
|
|
9/1/09
|
Ontario | Smith | Desk |
2
|
125.00
|
250.00
|
|
9/18/09
|
Quebec | Jones | Pen Set |
16
|
15.99
|
255.84
|
|
10/5/09
|
Ontario | Morgan | Binder |
28
|
8.99
|
251.72
|
|
10/22/09
|
Quebec | Jones | Pen |
64
|
8.99
|
575.36
|
|
11/8/09
|
Quebec | Parent | Pen |
15
|
19.99
|
299.85
|
|
11/25/09
|
Ontario | Kivell | Pen Set |
96
|
4.99
|
479.04
|
|
12/12/09
|
Ontario | Smith | Pencil |
67
|
1.29
|
86.43
|
|
12/29/09
|
Quebec | Parent | Pen Set |
74
|
15.99
|
1,183.26
|
|
1/15/10
|
Ontario | Gill | Binder |
46
|
8.99
|
413.54
|
|
2/1/10
|
Ontario | Smith | Binder |
87
|
15.00
|
1,305.00
|
|
2/18/10
|
Quebec | Jones | Binder |
4
|
4.99
|
19.96
|
|
3/7/10
|
Alberta | Sorvino | Binder |
7
|
19.99
|
139.93
|
|
3/24/10
|
Ontario | Jardine | Pen Set |
50
|
4.99
|
249.50
|
|
4/10/10
|
Ontario | Andrews | Pencil |
66
|
1.99
|
131.34
|
|
4/27/10
|
Quebec | Howard | Pen |
96
|
4.99
|
479.04
|
|
5/14/10
|
Ontario | Gill | Pencil |
53
|
1.29
|
68.37
|
|
5/31/10
|
Ontario | Gill | Binder |
80
|
8.99
|
719.20
|
|
6/17/10
|
Ontario | Kivell | Desk |
5
|
125.00
|
625.00
|
|
7/4/10
|
Quebec | Jones | Pen Set |
62
|
4.99
|
309.38
|
|
7/21/10
|
Ontario | Morgan | Pen Set |
55
|
12.49
|
686.95
|
|
8/7/10
|
Ontario | Kivell | Pen Set |
42
|
23.95
|
1,005.90
|
|
8/24/10
|
Alberta | Sorvino | Desk |
3
|
275.00
|
825.00
|
|
9/10/10
|
Ontario | Gill | Pencil |
7
|
1.29
|
9.03
|
|
9/27/10
|
Alberta | Sorvino | Pen |
76
|
1.99
|
151.24
|
|
10/14/10
|
Alberta | Thompson | Binder |
57
|
19.99
|
1,139.43
|
|
10/31/10
|
Ontario | Andrews | Pencil |
14
|
1.29
|
18.06
|
|
11/17/10
|
Ontario | Jardine | Binder |
11
|
4.99
|
54.89
|
|
12/4/10
|
Ontario | Jardine | Binder |
94
|
19.99
|
1,879.06
|
|
12/21/10
|
Ontario | Andrews | Binder |
28
|
4.99
|
139.72
|
|
|
|
|
|
|
|
|
|
