Hi.  Dr. Nitin here
I'm going to show you how to create a
chart and use this explanation column as
data labels. I don't want to show the
numbers as data labels on the chart but
I want to explain why the chart behave
in particular matter so let's first draw a chart
simple line chart
now to add data labels all that you have to do is click on
the + sign and click on data labels but these
are the data labels. Actually what I want is
something else
the options.  Here I removed the data labels and
go to this option which is very
powerful. This asks you where are the
cell from where it should pick up the new
labels and this time I select the third column and
that's it
it picks  only those labels which have some text in it we also have another option
here which says add data labels but did
you notice that there is a menu there
which allows you a simple data labels or a data callout which looks like this. Now let's
refine these data labels click on the
data labels go to data label options
value from particular cells which is
this particular column and I click OK
obviously it does become too crowded, so I'm going to
remove the category name and value now
it is showing exactly what we want. If
you want to change the position of a
particular callout you can just click on
it and then only that callout is
selected and we can change its location.
having done that I want to give them a
more solid appearance so I'm going to go here and put some predefined format.  That's all for now.
If you like this video
share it with your friends and
colleagues also follow this YouTube
channel and my blog efficiency365.com thank
you
