In these steps, you need to prepare some charts showing trends in the sporting goods industry. A workbook containing a variety of information on industry-wide trends has already been created. You will begin with data showing the number of people who participate in a variety of sports and activities.

1-

The 2017 Participation worksheet contains participation data for a variety of sports, ranked in descending order by the values in the Total column.

1. Create a column chart, a bar chart, and a line chart from the data. Place each chart on the same worksheet as the source data.

2. b) In an area below each chart, explain what the chart type emphasizes about thedata. Decide which chart is the best choice for comparing each sports participation level

3. d) Return to the 2017 Participation worksheet, and in an area below the chart you selected to place on the chart sheet, explain the advantages and any disadvantages of this chart.

Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF 3-1-Trends-1 raw Home Insert Draw Page Layout Formulas Data Review View Tell me bri Calibri (Body) 11 ' General Conditional Form 1 Paste BIU a Av $ % ) Format as Table Cell Styles orkb Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? keep Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A46 A B Maj Coc 1 2017 Participation - Ranked by Total Participation 2 3 Participated more than once (in millions) Seven (7) years of age and older 5 6 Sport Total 7 Exercise Walking 86.776 8 Camping (vacation/overnight) 65.832 9 Swimming 56.076 10 Exercising with Equipment 55.216 11 Fishing 54.412 12 Bowling 40.712 13 Bicycle Riding 40.124 14 Billiards/Pool 38.736 15 Hiking 34.728 16 Aerobic Exercising 33.320 17 Basketball 32.564 18 Golf 30.940 19 Weight Lifting 29.304 20 Boating, Motor/Power 25.348 21 Running/Jogging 24.848 22 Roller Skating in-line) 22.212 23 Dart Throwing 21.676 24 Baseball 18.688 25 Backpack/Wilderness Camp 17.524 26 Mountain Biking (on road) 16.452 mber 1-2017 Particination 2-10-Year Particination 3-Female Snart Particination 4-Customer Fainment Purchase Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF 3-1-Trends-1 raw Home Insert Draw Page Layout Formulas Data Review View Tell me bri Calibri (Body) 11 ' General I Conditional Forma 1 Paste