0:00
so let's get the target onto our chart
0:03
so let's right click and we're going to
0:05
select some more data to add to our
0:07
chart and we're going to add a series of
0:10
data let's choose the series name which
0:12
is Target and our series values are in
0:19
here let's hit okay and now it doesn't
0:22
look quite what we want because the
0:24
target has been put alongside each of
0:26
our sales values that's fine what we
0:28
need to do is just change change that
0:31
series chart type this is the area we
0:34
want so this is where we can change this
0:35
Target and if we just hit where it says
0:38
clustered column the drop down will give
0:40
you lots of options just select line and
0:42
then hit okay that immediately changes