4271 Starting Graphs - Exercise 1
Create graphs from the data collected in class on "Favourite Subjects"
1. Open MS Excel
2. Create the tally chart in your exercise book
3. Create a data table in excel
4. Create a pie chart from the data table
a. Highlight data table (select and drag)
b. Select Insert…..Pie
5. Create a bar chart from the data table
a. Highlight data table
b. Select Insert …. Bar
6. The Bar chart is now on top of the Pie Chart. Select and drag the Bar chart below the Pie Chart
7. Preview your print and ensure that it in one 1 page only
Your final product should include the following:
1. Open MS Excel
2. Create the tally chart in your exercise book
3. Create a data table in excel
4. Create a pie chart from the data table
a. Highlight data table (select and drag)
b. Select Insert…..Pie
5. Create a bar chart from the data table
a. Highlight data table
b. Select Insert …. Bar
6. The Bar chart is now on top of the Pie Chart. Select and drag the Bar chart below the Pie Chart
7. Preview your print and ensure that it in one 1 page only
Your final product should include the following:
- Table Data
- Bar Chart (show Heading, label the x-axis and y-axis)
- Pie Chart
- Show headings for each chart
- If applicable label the x-axis and y-axis
- Include a legend
- All information must be on 1 page (i.e. do a "print preview" before printing)