Excel Charts

Unit 5 Assignment –Excel Charts

CIS112 – Introduction to Computing

Due: Midnight Sunday of Unit 5.

In this assignment, you will create and format a 2D line graph and a 2D pie chart using data provided.

The requirements for your assignment are:

1. Open a new Excel workbook in your OneDrive course folder.

2. Change the name of the worksheet to "Charts". 

3. Enter the following data into this worksheet: 

4. Create a 2D line graph with markers displaying the monthly sales data.

a. Edit the graph title and change it to "Sales Summary" 

b. Move the legend to the right side. 

c. Add data labels above the markers.

d. Label the vertical axis “DOLLARS”.

e. The graph should look like this: 

5. Create a 2D pie chart displaying the same monthly sales data. 

a. Edit the graph title and change it to "Sales" 

b. Move the legend to the left side. 

c. Add data labels outside the end of the data points. 

d. The chart should look like this:

s

6. Rename the document to yourinitials_Exce12.xlsx

Refer to the grading rubric below for the grading criteria.

Students: Be sure to read the criteria, by which your paper/project will be evaluated, before you write, and again after you write.

Evaluation Rubric for Unit 5 Assignment

Criteria	Deficient	Proficient
	0-9 points	10 points
Data	Data is incorrectly entered.	Data is entered correctly.
	0-39 points	40 points
Line Chart	The chart type or data selected is incorrect or at least one of the formatting requirements is not done correctly.	2D line chart with markers is the chart type displaying all the monthly sales from the data. The title is “Sales Summary”. The legend is on the right. Data labels are displayed above the markers. The vertical axis is correctly labeled “DOLLARS”.
Pie Chart	The chart type or data selected is incorrect or at least one of the formatting requirements is not done correctly.	2D pie chart is the chart type displaying all the monthly sales from the data. The title is “Sales”. The legend is on the left. The data labels are outside of the data end points.
	0-9 points	10 points
Excel document name	File name is incorrect.	File name is named correctly