A B C
1
Meal Price
Restaurant Quality Rating ($)
2 1 Good 18
3 2 Very Good 22
4 3 Good 28
5 4 Excellent 38
6 5 Very Good 33
7 6 Good 28
8 7 Very Good 19
9 8 Very Good 11
10 9 Very Good 23
11 10 Good 13
Sales ($100s)
Month North South
Jan 95 40
Feb 100 45
Mar 120 55
Apr 115 65
May 100 60
Jun 85 50
Jul 135 75
Aug 110 65
Sep 100 60
Oct 50 70
Nov 40 75
Dec 40 80
Manager Accounts Managed
Davis 24
Edwards 11
Francois 28
Gentry 37
Jones 15
Lopez 29
Smith 21
Williams 6
Billionaires per 10M
Country Residents Per Capita Income Number of Billionaires
United States 13.2 48300 412
China 0.9 8300 115
Russia 7.1 16800 101
Mexico 0.4 14600 40
Hong Kong 51 49300 36
United Kingdom 5.3 36000 33
Select B2:D7, then choose Scatter or Bubble Chart from the Insert menu.
To put the Country names on the chart:
1. Double-click the chart.
2. Click Add Chart Element in the Chart Layouts group
3. Choose Data Labels from the drop-down menu
4. Click More Data Label Options . . .
5. Click the Label Options icon
6. Under LABEL OPTIONS, select Value from Cells, and click the Select Range button
7. When the Data Label Range dialog box opens, select cells A2:A7 in the Worksheet and OK.
8. In the Format Data Labels task pane, deselect Y Value in the LABEL OPTIONS area, and select Right under Label P
d select Right under Label Position
JAN FEB MAR APR MAY JUN JUL AUG SEP
St. Louis -2% -1% -1% 0% 2% 4% 3% 5% 6%
Phoenix 5% 4% 4% 2% 2% -2% -5% -8% -6%
Albany -5% -6% -4% -5% -2% -5% -5% -3% -1%
Austin 16% 15% 15% 16% 18% 17% 14% 15% 16%
Cincinnati -9% -6% -7% -3% 3% 6% 8% 11% 10%
San Francisco 2% 4% 5% 8% 4% 2% 4% 3% 1%
Seattle 7% 7% 8% 7% 5% 4% 2% 0% -2%
Chicago 5% 3% 2% 6% 8% 7% 8% 5% 8%
Atlanta 12% 14% 13% 17% 12% 11% 8% 7% 7%
Miami 2% 3% 0% 1% -1% -4% -6% -8% -11%
Minneapolis -6% -6% -8% -5% -6% -5% -5% -7% -5%
Denver 5% 4% 1% 1% 2% 3% 1% -1% 0%
Salt Lake City 7% 7% 7% 13% 12% 8% 5% 9% 10%
Raleigh 4% 2% 0% 5% 4% 3% 5% 5% 9%
Boston -5% -5% -3% 4% -5% -4% -3% -1% 1%
Pittsburgh -6% -6% -4% -5% -3% -3% -1% -2% -2%
OCT NOV DEC
7% 8% 8%
-5% -7% -8%
-2% -1% -2%
19% 18% 16%
11% 13% 11%
-1% 1% 2%
-4% -6% -5%
10% 9% 8%
8% 5% 3%
-13% -11% -10%
-2% -1% -2%
1% 2% 3%
9% 7% 6%
11% 8% 6%
2% 3% 5%
-1% -2% -1%
Bicycle Costs
Purchase Quantity
ID Product Name Cost on Hand Inventory Value This chart isn't available in your version of Exce
20 Runroad 5000 $450.95 5 $2,254.75
18 Runroad 1000 $250.95 8 $2,007.60 Editing this shape or saving this workbook into
11 Elegant 210 $281.52 7 $1,970.64
19 Runroad 4000 $390.95 5 $1,954.75
9 Eagle 3 $350.52 5 $1,752.60
5 Classic 109 $207.49 7 $1,452.43
10 Eagle 7 $150.89 9 $1,358.01
23 Tea for Two $429.02 3 $1,287.06
2 Bluff Breaker $375.00 3 $1,125.00
8 Eagle 2 $401.11 2 $802.22
4 Breeze LE $109.95 5 $549.75
17 Runkidder 100 $50.95 10 $509.50
13 Jetty Breaker $455.95 1 $455.95
16 Runcool 3000 $85.95 5 $429.75
6 Coolest 100 $69.99 6 $419.94
7 Eagle 1 $410.01 1 $410.01
12 Green Rider $95.47 4 $381.88
3 Breeze $89.95 4 $359.80
1 Blue Moon $75.29 4 $301.16
22 Supreme 350 $50.00 3 $150.00
14 Red Rider $15.00 8 $120.00
21 Starlight $100.47 1 $100.47
15 Runblend 2000 $180.95 0 $0.00
24 Twist & Shout $490.50 0 $0.00
ilable in your version of Excel.
or saving this workbook into a different file format will permanently break the chart.
Quality Rating Average of Wait Time (min)
Excellent 32.1212121212121
Very Good 12.32
Good 2.46428571428571
Total Result 13.9166666666667 This chart isn't available in your version of Excel.
Excellent 32.1212121212121 Editing this shape or saving this workbook into a different f
Very Good 12.32 permanently break the chart.
Good 2.46428571428571
r version of Excel.
s workbook into a different file format will
