Question

Using the data shown, you will create two charts. The first chart is a bar chart that will display % growth in different job titles between 2010 and 2020Est. The second chart will be a pie chart showing the 2020Est. Jobs in different categories as a % of overall 2020Est. jobs.

Computer-Related Jobs
	2010	2020 Est.	% Change
Systems Analysts	544,400	664,800
Software App Developers	520,800	664,500
Programmers	363,100	406,800
Network/System Admins	347,200	443,800
CIS Managers	307,900	363,700
Info Security Analysts	302,300	367,900
Database Administrators	110,800	144,800

Answer 1

Suppose job title is in column A ,2010 data in column B and 2020 Est data in column C then

For the calculation of % change type below formula in first row under the % change Column =(C2-B2)/B2 then click the percentage style button (%) in the number group under Home tab to format the cell as percentage.

Step 1:

Highlight the data that you would like to use for the bar chart. In this     example, we have selected   the range A2:A8, D2:D8

Step 2:

Click on Insert tab in the toolbar at the top of the screen. Click on the Bar Chart button Microsoft Excel in the Charts group and then select a chart from the drop down menu.

Step 3:

The bar chart appear in your spreadsheet with horizontal bars to represent both the job title and percentage growth for each job

Step 4:

Update the title for the bar chart, Axis Titles and data labels by clicking on plus icon

Suppose we are calculating % of total in E column.

For the calculation of % total first find total of 2020 Est. in cell C10 using below formula =SUM (C2:C8)

In first row under the % of total Column type =C2/$C$10 here $ sign is used because that value is not changed when formula is copied down column E.

For adding Pie chart follow below step

Step 1

Highlight the data that you would like to use for the bar chart. In this     example, we have selected   the range A2:A8, E2:E8.

Step 2

Click on Insert tab in the toolbar at the top of the screen. Click on the Pie Chart button Microsoft Excel in the Charts group and then select a 2-D Pie chart from the drop down menu.

Step 3:

The Pie chart appear in your spreadsheet

Step 4:

Update the title for the chart, Legend and data labels by clicking on plus icon

At any point if you find any difficulty feel free ask me.