How do I make a simple line graph in Excel?
Create a line chartCopy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a line chart.
Select the data that you want to plot in the line chart.Click the Insert tab, and then click Insert Line or Area Chart.Click Line with Markers.More items….
Can you graph with Excel?
Select the data for which you want to create a chart. Click INSERT > Recommended Charts. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look. … When you find the chart you like, click it > OK.
How do I turn Excel data into a graph?
How to Make a Graph in ExcelEnter your data into Excel.Choose one of nine graph and chart options to make.Highlight your data and ‘Insert’ your desired graph.Switch the data on each axis, if necessary.Adjust your data’s layout and colors.Change the size of your chart’s legend and axis labels.More items…•
How do I draw a bar graph in Excel?
To create a column chart, follow these steps:Enter data in a spreadsheet.Select the data.Depending on the Excel version you’re using, select one of the following options: Excel 2016: Click Insert > Insert Column or Bar Chart icon, and select a column chart option of your choice.
How do I create a comparison chart in Excel?
To insert a chart:Select the cells you want to chart, including the column titles and row labels. These cells will be the source data for the chart. … From the Insert tab, click the desired Chart command. … Choose the desired chart type from the drop-down menu. … The selected chart will be inserted in the worksheet.
Which chart can be created in Excel?
Greetings. Today we will discuss the most common chart types supported by Microsoft Excel and provide many sample charts.