For example, If there are more datasets with different scales, we can change the scale of the axis. The scale of the axis can be changed if there is a requirement. The color of the legend can also be changed, as shown in the below screenshot. We should place the cursor in the “Chart Title” area, and we can write a user-defined name in place of the chart title. We can change the chart title as per the user requirement for better understanding or the same as the table’s name for a better experience. These are some default customizations made to a line chart in Excel. The “filter” symbol indicates what we should represent as part of the data on the graph. The “paint” symbol is used to select the style of the chart to be used and the color of the line. The “+” symbol will have the checkboxes of what options to select in the graph to exist. The three options on the top right side of the graph are the graph options to customize them. We can select the types of gridlines as per the requirement or remove the grid lines completely. It can be done by right click on the chart.įormatting the grid lines: Gridlines can be removed or changed as per our requirement by using an option called formatting grid lines. We can customize the graph after inserting the line graph, such as formatting grid lines, changing the chart title to a user-defined name, and changing the axis’s scales. We can represent customer purchase % by using an orange color line, Sales by grey line, and the last one profit% by using a yellow line. In the above example, revenue is represented by a blue line. The different data set is represented using another color legend. We can also represent the line graph for multiple datasets. The data having a single data set can be represented in Excel using a line graph over a period. Relevance and Uses of Line Graph in Excel We can also represent a line graph with points for easy understanding.įor example, sales of a company during a period, salary of an employee over a period, etc. If the data contains years of data related to time, it can be presented better than other graphs. In the line graph, if there are multiple datasets to represent the data, and if the axes are different for all the columns, we can change the scale of the axes and represent the data.įrom this line graph, we can easily represent timeline graphs. It is the area where we can plot the graph. It is more useful when the graph contains more than one line to define. Next, 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. We can represent the above explanation in the below diagram.
One more component is “plot area.” It is the area where it will plot the graph. There is one more component called “legend.” It is the line in which the graph is represented. Then, the line chart in Excel created looks like as given below: Line Chart in Excel Example #2 Next, select the “Line” graph from “Charts.” It will display the required chart. Select all the data and go to the “Insert” tab. In the above graph, we have multiple datasets to represent that data. Here is an example of creating a line chart in Excel. We can use the line graph in multiple data sets also.
#How to plot a graph in excel with four columns how to
How to Make a Line Graph in Excel?īelow are 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 When 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. So, we can use this to represent data for every important point. This type of line graph in Excel will contain pointers at each data point.
0 kommentar(er)
