00:00one in this video i will guide you how to make a line graph in excel making a line graph
00:05in excel
00:06is a straightforward process so first you need to click and drag your mouse to highlight all the
00:13cells that contain the data you want to include in the graph so make sure to include the header
00:20columns in your selection and then navigate to the insert tab on the excel ribbon at the top of
00:27the screen click on that and in the chart group you need to insert the line or the area chart
00:35click
00:35on that and at the drop down menu will appear choose the style you prefer under the 2d line and
00:43here it
00:43is i'll be prefer this style so once you click the preferred style actually instantly generate the
00:50graph and drop it onto your worksheet so a standard line graph will be inserted and the these dots
00:57at each data point which is the highly recommended for making individual data pointers to easier to
01:04read so if you want to change the title double click the placeholder text the chart title on
01:11the graph and type in the descriptive title for example sales chart click outside so if you want
01:22to change the style or color for this you need to select the chart and click on the chart design
01:27on the
01:28top ribbon and then browse the pre-made chart styles like this one if you want prefer this style you
01:36can
01:37select it it's up to you which one you like it so if you add anything in the data you
01:48can just right click
01:49and click insert and add anything which you like for example i'll be added another sales of the gawa and
02:00similar prices like this one whatever you like it so this is done
02:11so if you want to change the color of the line you need to select the line and click on
02:17the format tab
02:18tab on the top ribbon and go to the shape outlines click on that and change the color of your
02:25choice
02:25for example red one there is you can see that and similar for that go to the format change the
02:34color
02:34of your choice to green like this one if you want to change the color of the values then select
02:41it
02:42and go to the format and again go to the shape outline and select the color of your choice
02:49and you can also fill the effects like yellow here you can see that moreover if you don't want to
02:57show
02:57these numbers click on this plus icon and uncheck the data labels and here you can see that if you
03:04want
03:04to show it again click on the data labels and you can also show the data table under the chart
03:12if you want
03:12to insert it like this one and you can also show the error bars like this one you can also
03:22show the up and
03:23down bars go to the this and click on more option and you can also select the pattern fill like
03:33this one
03:33here you can see that you can also fill the gradient choose the force color and here you can select
03:41the
03:43second color you can make another point to edit and change the color to the yellow and here it is
03:51the
03:51gradient color so you need to play around it and then you will learn that how you can insert a
03:57line
03:58graph in excel so i hope this is pretty simple and straightforward i hope you like the video
04:02if you think this video is helpful to support my channel thanks for watching
Comments