Kick off the new school year with lessons from our Back to School 2022 collection to help students express themselves, build relationships, and stay organized.

Create a Chart to Compare Job Outlooks

Playback Speed:
Transcript

In this extension, you will create a chart to compare the job outlook for the careers you researched. A chart can help you with your career exploration by enabling you to more easily visualize the information. You will use the Chart feature in Google Sheets to create your chart. In this extension, you will: Insert a chart and enter data ranges, Select a chart format, Give your chart a title and label the bars, Customize your chart, And move and resize your chart.

To begin, select a random cell below all of your data in your sheet.

Then insert a chart.

To enter data into your chart, use the chart editor. First, select a data range. Add the letter and number of the cell which shows the average projected growth for the first career on your sheet.

Add data ranges to show projected growth percentages from any additional careers listed on your sheet. Your chart will automatically be populated with this data. Use the chart editor to select from a variety of different chart formats.

Choose the format that will best illustrate the data you want to present.

Give your chart a title that clearly describes the information it shows and bold it.

Then label the bars with the corresponding career titles.

Now customize your chart to make it look exactly the way you want.

For example, you can change the background color and the font of the text in your chart.

Now move and resize the chart on your spreadsheet as you prefer.

You’ve now created a chart that will help you more easily visualize and understand the job outlook for the careers you’ve researched.

As you add more careers to your spreadsheet, you can add their data to your chart, as well.

Now, it’s your turn: Insert a chart and enter data ranges, Select a chart format, Give your chart a title and label the bars, Customize your chart, And move and resize your chart.

Choose an Extension
Format Your Spreadsheet

Use formatting tools such as borders, shading, and text color to further organize the information in your spreadsheet.

Create a Chart to Compare Job Outlooks

Create a chart to compare the projected growth rates of one of the careers you researched.

Add a Table to Summarize Research Results

Add a table to summarize the data you researched about different careers.