2) Create the document below and share to tawilliams@conroeisd.net
Period | Lastname, Firstname | European Soccer 2013
- Watch the video
- Log in
- Type in username (example: jaramirrez)
- Type in stu and then your five digit password (example: stu95432)
- First Sheet: European Soccer data
- Font: Arial
- Size: 18
- Bold first row
- Rename chart to "Data"
- Second Sheet: Bar Chart
- Highlight the data
- Press the "Insert Chart" button
- "Switch rows / columns" must be checked
- "Use column A as labels" must be checked
- Choose Charts - Bar - Bar Chart
- Press Insert
- Click on chart
- On the top right, press the arrow and choose "Move to own sheet"
- Click Advanced Edit
- Change "Chart Title" to "Best European Soccer Teams"
- Horizontal axis
- Change "Horizontal axis title" to Titles
- Give Titles a Min of 0 and a Max of 35
- Check Allow Bounds to Hide Data
- Change Gridlines Major to 8
- Vertical axis
- Change "Left vertical axis title" to Types
- Colors
- Change Barcelona to Orange
- Change Real Madrid to Gray/Silver
- Change Manchester United to Yellow
- Change Chelsea to Blue
- Change Inter Milan to Black
- Change AC Milan to Red
- Change Bayern Munich to Light red/Pink
- Rename Chart to "Bar Chart"
- Third Sheet: Stacked Bar Chart
- Highlight the data
- Press the "Insert Chart" button
- "Use row 1 as headers" must be checked
- Choose Charts - Bar - Stacked Bar Chart
- Press Insert
- Click on chart
- On the top right, press the arrow and choose "Move to own sheet"
- Click Advanced Edit
- Change "Chart Title" to "Best European Soccer Teams"
- Horizontal axis
- Change "Horizontal axis title" to Titles
- Give Titles a Min of 0 and a Max of 70
- Check Allow Bounds to Hide Data
- Change Gridlines Major to 8
- Vertical axis
- Change "Left vertical axis title" to Teams
- Colors
- Change League Titles to Gray/Silver
- Change Domestic Cup Titles to Brown/Bronze
- Change Champions League Titles to Dark Yellow/Gold
- Change Titles in Five Years to Second to Darkest Green
- Rename Chart to "Stacked Bar Chart"
- Fourth Sheet: Titles in the Last Five Years Bar Chart
- Data
- Highlight the first column "Teams" (Data!A1:A8)
- Press Insert Chart
- Press the "Get Data Range" button
- Press Add Another Range
- Highlight the column Titles in Last Five Years (Data!E1:E8)
- Click OK
- Click "Use row 1 as headers"
- Choose Charts - Bar - Bar
- Click Insert
- On the top right, press the arrow and choose "Move to own sheet"
- Click Advanced Edit
- Change "Chart Title" to "Best European Soccer Teams"
- Horizontal axis
- Change "Horizontal axis title" to Titles
- Give Titles a Min of 0 and a Max of 8
- Check Allow Bounds to Hide Data
- Change Gridlines Major to 9
- Vertical axis
- Change "Left vertical axis title" to Teams
- Colors
- Change Titles in Five Years to Second to Darkest Green
- Rename Chart to "Titles in the Last 5 Years"
- Fifth Sheet: Barca vs. Real Bar Chart
- Data
- Highlight the first three columns (Data!A1:E3)
- Check "Switch rows / columns"
- Check "Use column A as headers"
- Press Insert Chart
- Click Advanced Edit
- Change "Chart Title" to "Barca vs. Real"
- Horizontal Axis
- Change "Horizontal axis title" to Titles
- Give Titles a Min of 0 and a Max of 40
- Check Allow Bounds to Hide Data
- Change Gridlines Major to 9
- Vertical axis
- Change "Left vertical axis title" to Types of Titles
- Colors
- Change Barcelona to Orange
- Change Real Madrid to Gray/Silver
- Rename Chart to "Barca vs. Real"
