This is the area where the Graph can be plotted. This is more useful when the graph contains more than one line to represent. The Legend is the blue line in which the graph is represented. The X-axis and Y-axis are used to represent the scale of the graph. The above explanation can be represented in the below diagram. This is the area where the graph will be plotted. There is one more component called “Legend.” It is the line in which the graph is represented. The Horizontal Axis is called X-Axis, and the vertical Axis is called Y-axis. They are Horizontal axis and vertical axis. To represent a Line graph in excel, we need 2 necessary components. This is the basic process of how to use a line graph in our representation. Then the Chart looks like as given below.Go to Insert Menu -> Charts Tab -> Select Line Charts Symbol, and in that, we can select the customized line chart as per the requirement.From those columns, that data is represented in Pictorial form using a line graph. The Employee names are taken on X-Axis, and Salary is taken on Y-Axis. Those 2 columns are represented in a line chart by using a basic line chart in Excel. Then the line chart in excel created looks like as given below: Line Chart in Excel Example #2 Select all the data and go to Insert Tab, select Line graph from Charts, and then the required chart will be displayed. In the above graph, we have multiple datasets to represent that data also, we have used a line graph. Here is the example for creating a line chart in excel. The Line graph can be used in multiple data sets also. How to Make a Line Graph in Excel?īelow are the examples to create a Line chart Examples To Create A Line Chart The line chart is a graphical representation of data that contains a series of data points with a line. As per the requirement, you can create the line chart in excel. The representation is different from chart to chart. All the lines are represented in 3D format.Īll these graphs are types of Line charts in Excel. The below line graph is the 3D line graph. This line graph in excel is shown in 3D format. Stacked Line with Markers 100% Stacked Line with Markers #2 – 3D Line Graph in Excel On hovering the mouse on the point, the values corresponding to that data point are known. The Point marks represent the data points where they are present.

This can be used to represent data for those every point is important. This type of line graph in excel will contain pointers at each data point.

Select data for graph in excel mac