{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

comp_pset1

# comp_pset1 - Computer Problem Set 1#1 Bar Graph 1 Insert...

This preview shows pages 1–3. Sign up to view the full content.

Computer Problem Set 1 #1 Bar Graph 1. Insert the following data into an Excel worksheet. Education Count (millions) Percent Less than high school 4.6 11.8 High school graduate 11.6 30.6 Some college 7.4 19.5 Associate degree 3.3 8.8 Bachelor’s degree 8.6 22.7 Advanced degree 2.5 6.6 2. Adjust the columns to fit the width of the labels and heading (Put your mouse pointer on the line between the column labels and then click and drag until you read the desired width. Or put your mouse pointer on the line between the column labels and double left- click). 3. We want to graph the Education column and the Percent column, without the headings. To select two non-adjacent columns of data, select the first column, hold the Control key down, and select the second column (while holding down the Control key). 4. Click the ChartWizard in the toolbar (bar graph icon). Chart type options are displayed in Step 1. Select Column chart (note that what we call a “bar graph” in class, Excel calls a “Column chart”). Accept the default Chart sub-type. Hit Next. 5. Step 2 of the ChartWizard displays a preview of the chart. Hit Next. 6. Step 3 of the Chart Wizard allows you to input Chart Options. Under Titles, label the chart “Education Levels for Age 25 to 34 Years- Your Name.” Label the X axis “Highest Education Level.” Label the Y axis “Percent of People Aged 25 to 34.” 7. Click Gridlines and deselect Major Gridlines for the y axis. 8. Click Legend and de-select Show Legend (we don’t need a legend if only ones series of data is graphed). Click Next. 9. Step 4 of the ChartWizard has two options for chart location- a new sheet or an object in the current worksheet. Select “As new sheet” and click Finish. 10. Print your bar graph (make sure your name is in the graph’s title).

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
#2 Pie Chart 1. Select the Education data and the Count data, without the headings. Click ChartWizard. Select Pie as the Chart type and accept the default Chart sub-type. Hit
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 5

comp_pset1 - Computer Problem Set 1#1 Bar Graph 1 Insert...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online