Explore BrainMass
Share

# Excel help with Grade Chart

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Using your cursor, highlight the course names and the data that is next to them.
Click on Insert > Charts, and select "Column Chart."
Click on the chart, and select "Cut."
Go to the bottom of your spreadsheet, and select Sheet 2. Click on a cell within that sheet.
On Sheet 2, paste the chart you just copied.
On the tabs at the bottom, label Sheet 1, as "Data" and Sheet 2 as "Grade Chart."
Revise the chart as needed to make it look more presentable.

#### Solution Summary

Using your cursor, highlight the course names and the data that is next to them.
Click on Insert > Charts, and select "Column Chart."
Click on the chart, and select "Cut."
Go to the bottom of your spreadsheet, and select Sheet 2. Click on a cell within that sheet.
On Sheet 2, paste the chart you just copied.
On the tabs at the bottom, label Sheet 1, as "Data" and Sheet 2 as "Grade Chart."
Revise the chart as needed to make it look more presentable.

\$2.19
Similar Posting

## Statistics: Practice Problems For an Excel Chart a. Determine the types of measurement scales for each variable (Nominal, Ordinal, Interval, Ratio) ... b. Determine the number of boys and girls in the class and create a bar graph or pie chart to display the information. c. Determine the correlations between pairs of all interval variables (i.e., Absences with PE, PE with math, math with writing, etc.) d. How much of the math grade can be explained by the PE grade? How much of the writing grade can be explained by the reading grade?

Practice Problems For an Excel Chart

a. Determine the types of measurement scales for each variable (Nominal, Ordinal, Interval, Ratio):
1) Name
2) Gender
3) Absences
4) Physical Education (PE)
5) Math
6) Writing