Embedded Files
OverviewThe ability to compare data and evaluate changes in data is easily done using charts. Charts are visual representations of data. They can quickly show the reader, for example, cost comparisons of various items, the performance of each salesperson at a dealership, or the amount of inventory in each department of an organization. In presentations, charts are very powerful tools when reporting data to a group of people or to an organization. It is important to know how to develop charts to accurately represent the data you wish to showcase.
In this section, you will
study charts and chart types
discover the effects of changing the data in a chart
move charts
resize charts
create a pie chart
change chart layouts
format charts
add and modify graphics
print charts
To successfully complete this section, read the instructions for pie charts and column charts. In EdPuzzle, watch:
Instructions /11
Complete the following steps in order. You will create charts on two separate worksheets: the Pie Chart worksheet and the Columnar Chart worksheet.
Step 1: Open Charts. Save your copy as Charts - Firstname Lastname in your Practice folder.
Part 1: On the Pie Chart worksheet, complete these steps:
/1 Step 2: Create a pie chart of the expenses for What a Wonderful World Travel. Do not include the Totals.
/1 Step 3: In Customization, title the pie chart “Expenses.”
/1 Step 4: Portray the slice labels as percents. You'll find this in the dropdown menu for pie chart customization if you right-click the chart.
/1 Step 5: Resize the chart appropriately (i.e., so everything is able to be read clearly and easily), and place it below the table.
/1 Step 6: Format the background to be light blue.
Part 2: On the Columnar Chart worksheet, complete these steps:
/1 Step 7: Create a columnar chart for What a Wonderful World Travel that highlights Brockhoff’s information (ensure that you select only Brockhoff’s information).
/1 Step 8: Title the columnar chart “Brockhoff’s Expenses.”
/1 Step 9: Remove the legend.
/1 Step 10: Format the labels for Auto Rental, Air Fare, etc., to 10-point Arial bold.
/1 Step 11: Slant the labels to 60 degrees and resize so that they are easy to read.
/1 Step 12: Format the bars to make them red.
Step 13: Compare your Charts to the example here. Submit your Charts on Google Classroom for assessment.
Page updated
Report abuse