we're gonna talk today about creating a Gantt chart from the existing data that
you have an Excel let's look at the data that I have here I have the task list
and then I have the start date and then I have the end date most important in
this chart here I have the duration between the start and the end date and
what I am diane is I have done if formula so that even if the dates are to
exactly the same I always put a one because that is quite often the
milestones you need to have it marked on your Gantt chart so what we're gonna do
is select the data and then we're gonna go to the Insert tab and we're gonna
select the horizontal bar chart and were select one with different levels now
we can drag it across our data a little bit ok so we have a little problem here
with the date range so let's so what they've done is they've put in a format
the date range they have put it in number value so what I'm gonna do is I'm
gonna scroll down my numbers here and the earliest start date I have is the
10th I believe so let's copy that one and then let's just go further down here
and go paste
now what I do is I am going to highlight that cell and I know format that cell
and I'm gonna put it into number I'm gonna say okay so there you see that our
number is 42195 now I wanted to start a little bit earlier than that and
so I am now I'm going to go and I'm gonna right click on my horizontal axis
here my x axes and I'm format axes so we know that our first date is 42195
so let's put in here for the minimum has put in for 4192 as the start and
then just because I'm guessing more than anything else I wanted to go a little
bit past it so I'm gonna go 42220 and press Enter
so there we have the correct the correct date for our range so now the blue here
is our start date and the gray is our end date so we really don't need the
end on this chart so let's we have the charger clicked and so we go to the
Design tab and we select data the select data box here and so let's click on
the end and let's re tmove that and then will say okay and then we really don't need
to see the start date either so let's right click on one of these and thats
format data series and let's go to the paint option to paint an option here so
I want no filll on this and then down a little bit and I want the border to be
no line
and then click someplace else and so there you have there you have your
duration of your tasks now though there's one last thing to do here and
that's right click on the task list here and lets format axes when I'm gonna do
is drag down a little bit further and I'm going to select categories in
reverse order so there you have your Gantt chart made from the data that you
already have in excel plz subscribe