We would like to create our first charts in
Excel and we'd like to analyze data for seven
computer-related jobs from, the information is
from Bureau of Labor Statistics as you can see
over here. You have the link. And let's see what we
have. So I'm going to show the formulas CTRL
and the grave accent which is below the escape
key.
Looks like we have some formula. So we have
numbers for 2016 for each of these jobs. And then
we have a number of new jobs that is estimated.
And then for 2026 it will be those
two numbers added. So 2016 plus number of new
jobs. All right. Let me push escape. CTRL
+ grave accent (`) or tilde (~) again. And then we have
percent of growth. So let's double click over
here. The percent of growth would be the
difference. So it would be 173,000 the blue minus the
red, divided the by the red. So it started from the
red. It went up to the blue. So that's the
difference. And then we divide by the starting
point to see the percent of growth. We would like
to show in a chart the data for 2016, 2026 and
also the number of new jobs. So we have to select
all these data. Also let's go ahead and select the
job title as well. When you make your selection
for any chart you don't start from here because
you want to take 2016 and so on. So I'm going to start from
A5 even if it's a blank cell. So
let's go ahead and select from A5 to be able
to take 2016, 2026, number of new jobs. And now we
are moving down, take all the numbers, take all the
labels over here. And we are ready to create our first
chart. So we go to Insert tab and then you have a
group over here called Charts. And let's go ahead
now and click on the column chart. And we'll go with
the first option which is called Clustered Column. As
you hover your mouse over the options, it'll show
you how it looks. So we click on this one. And
that's our first chart. We can move it. Let's go
ahead and move it to H1 so it goes in the corner
right there. Now we are supposed to change the
size. So when you have a chart you're going to
get two tabs: Design, and just go ahead and play
with the options. You know just have some fun with
all  the buttons, change colors, styles and so on. And then
you go to Format. And you can play there too. And right
now from the Format. What I want to do is I want
to make the height three point five so I can go here
and I can just type the number I want. And then I go
to the next option: I pushed TAB. Now I can type five
point three and I push ENTER to finalize. Let's create
now a bar chart. You'd like to show in the bar
chart the 2016 numbers and also the addition of
these new jobs in column D. So if you remember we
need to have all these labels. Then we need to
have the numbers. But we also need to have the
column headings. So for that reason we need to be
on the same row to get the same number of cells
for each selection. So let's go ahead and select
A5 to B12. And now I'm supposed to take
from column D. So that's not adjacent. So let's
go ahead and hold down CTRL. Now we can go from
D5 down to D12. We have the selection, we can let
go the control and the mouse. And let's go ahead
and choose from Insert tab: Recommended Charts.
It recommends a bar chart which is exactly what we want.
Let's push OK.
But if we look at the chart we see the orange is
the number of new jobs. What if we put the
orange in continuation of the blue bar. So we need
to change the chart type. Remember we have under
Design and Format, we have all kinds of options.
Then if you look under Design there is one option
Change Chart Type. You can also right click
and you are going to probably find that option:
change chart type. And from the bar we have stacked
bar. The stacked bar will do exactly what we
want. And then you have some more options like a
hundred percent stacked bar. You have to be careful
with  the 100 percent stacked bar because all the bars
would be put at one hundred and the blue would
be a percent. And the orange would be a percent.
As you can see here. So together they would make a
hundred. But if you want to see differences
between the computer jobs this is not a good idea.
So let's go ahead with the stacked bar and push OK.
Now you can see how the software developers would
be the biggest number here. The next thing you
want to do is move this chart to its own
worksheet. You don't have to copy paste but
instead you can right click or you can use Move
Chart from the ribbon. But let's right click. Choose
Move Chart. We want to move it to a new worksheet
and we can name it Bar Chart and push OK.
Let's move on now to new jobs worksheet. And we would
like to create here a pie chart. To create a pie
chart you are not going to select the headings
over here. We just take the labels and we take the
numbers. And then let's just this time... it's called
quick analysis as you can see this icon. And from
here. You have Formatting. You can choose Totals to
add SUM, Average. You can create Tables.
Sparklines. We're going to learn about sparklines. But right
now let's go to Chart and let's click on Pie. That's what
we want. Create a pie chart. And let's do the same
trick: Move the Chart to its own worksheet and let's name it
Pie Chart.
Let's click on the Outlook sheet. Now what we'd like to
do is put on the same chart the number of new jobs
and also put the percent of growth. Now the
percent of grow is basically six percent is zero
point zero six. So that's a very small number
compared to ten thousand five hundred. We're going
to create a special chart is called Combo or
combination chart. So we want to have this
information. And remember we also need to have the
job titles. So I'm going to start from the blue
here have the same number of cells selected. And
then remember the key to use to be able to select
from here. It's CTRL. So let's hold on CTRL
and let's select now D5 to E12.
And let's go to the insert tab. And we are looking
now for the combo. You can hover your mouse until
you find the chart. You can also click on the
launcher arrow over here to see all charts and you can
click on All Charts tab. And the Combo is the last
one.
And you can see here. The orange representing the
percentages. Let's try the second option. As you can
see now, it looks perfect. And let's go ahead
and click OK.
And that's the chart we have. The blue columns will
represent the number of new jobs and the orange
that is depicted on the right here, the numbers
You can see them on the right would be the percent of growth.
Let's go ahead and move the chart again. So right
click and move. We're going to move it to a new sheet
and name it Combo Chart.
