Highlight the data you want in the graph by clicking the top left cell and dragging to the bottom right cell. click "insert" → "line graph" icon (two intersecting line graphs) → click a graph style. click the graph to customize it. change the style, position, size, and name of the graph. part 1. Use your spreadsheet data to graph multiple lines. download article. 1. select the data you wish to graph. click and drag your mouse over the columns of data you wish to graph. drag your mouse from the top left corner to the bottom right corner of the data set you want to appear in your graph.
To create a multiple line graph, select the data. and then go to insert > charts group > line chart icon. if you want different graph styles like 2d or 3d graphs, get them from the line or area chart option here. we are going with a simple 2d line graph for now. and the final multiple line graph looks like this:. To create a line chart, execute the following steps. 1. select the range a1:d7. 2. on the insert tab, in the charts group, click the line symbol. 3. click line with markers. result: note: only if you have numeric labels, empty cell a1 before you create the line chart. Insert a line graph. with the source data selected, go to the insert tab > charts group, click the insert line or area chart icon and choose one of the available graph types. as you hover the mouse pointer over a chart template, excel will show you a description of that chart as well as its preview. Step 3: insert your line graph. now that you have your data selected, it’s time to create your line graph. go to the ‘insert’ tab on the excel ribbon and click on the ‘line’ graph option. from there, choose the type of line graph you want to make. step 4: customize your line graph.
Comments are closed.