Sparklines

(Part 1 - 5 points) Do some research on Excel sparklines. Explain what Sparklines are used for and how to create them in Excel. Be sure to discuss the three different types. (5 points)

(Part 2 - 5 points) The first tab in the data file (Sparklines) contains customer traffic information for several branches of a bank. Using the data, create line sparklines in cells I3 to I9. Include markers for each point, and make the Sparklines 2 point weight. Copy the whole table (A1:G9), including the Sparklines you created, into your answer document. (5 points)

Bubble Charts

(Part 1 - 5 points) Do some research on Bubble Charts. Explain what bubble charts are used for and how to create them in Excel. Be sure to include advantage(s) bubble charts have over other charts like column and line. (5 points)

(Part 2 10 points) The second tab in the data file (Bubble Chart) contains information about a product line, including the product line, the number of products in that line, the sales (in $) and the market share (as a percentage of the total market).

Using the data, create a 3-D bubble chart where each bubble represents one product:

• Number of products in the line is the X axis
• Sales is the Y axis
• Market share is represented by the size of the bubbles

Your chart should have a title, labels for the X and Y axis, and labels for each bubble showing which product line it is. You only need to copy the bubble chart (not the data table) into your document.

Notes:

For each Part 1 (Sparklines and Bubble Charts), make sure to cite your sources. You must have at least two (2) sources for each of the part 1s (four (4) sources total) and Wikipedia is not a source!

You do not need to repeat the questions on your answer sheet.

Make sure anything you copy and paste from Excel is completely shown on your hardcopy.

B D F G H. 1 1 E Traffic Thurs Branch Sparklines 2 Mon Tues Wed Friday Sat Sun 3 Neenah 859 1011 1242 1335 1650 1406 1314 4 Oshkosh 1314 1649 1185 1274 828 861 1716 5 Appleton 780 755 1627 701 852 1363 1472 6 Hortonville 1726 1295 789 1436 1238 1357 1120 7 Slab City 920 771 941 1007 1650 1684 1738 8 Green Bay 1395 1410 1493 1104 702 1539 1346 9 Fond du Lac 1037 1639 1509 1598 1271 1300 1014 1 2 3 . B C D Product Line Number of Products Sales ($) Market Share (%) A 36 18272 60% B 10 9987 26% 10 21690 34% D 32 11732 56% E 20 24914 78% 4 5 6 7 od