Graphs Comparing Two Sets Data

In Excel, a nautical chart besides referred to as a graph is used to graphically display data which can make information technology easier for the user to analyse and translate.

In this tutorial, we volition bear witness you how to compare revenue figures for two different years using a line graph.

Video Guide

Instructions

• Firstly you lot volition demand to setup your information to exist able to compare month to month acquirement.
• Once you take setup your data you lot demand to highlight all your data and then click 'Insert'. From the Insert card, nosotros will then demand to select the appropriate 'Line Graph'.
• Now that the graph has been automatically generated, we can movement and resize it to arrange our preference.
• One time you have formatted the graph, we can now requite the chart a title, you can practice this just past clicking on 'Chart Championship' and renaming it. If you lot do not have a default nautical chart title you lot can add this past clicking on 'Add together Chart Chemical element' -> Nautical chart Title -> To a higher place Chart.
• Now we can add Centrality Titles by clicking on 'Add together Chart Chemical element' -> Axis Title -> Primary Horizontal or Primary Vertical. We can call the Horizontal axis Calendar month and Vertical centrality Revenue.
• Next, we need to edit the Legend title, the Legend is the proper name of the ii lines that we volition exist comparison in this example these are the lines defining the yr 2017 and 2018.
• To do this correct click on the chart then click select data and so rename the legend entries past clicking on the outset legend entry and inputting 2017 into the 'Name' field then doing the same for the 2^nd
• Once this is washed click 'OK' and yous now accept your completed nautical chart.

Graphs Comparing Two Sets Data,

Source: https://simplifytasks.com/2018/05/04/how-to-create-a-chart-comparing-two-sets-of-data-excel-video-tutorial/

Posted by: jonesclumand.blogspot.com

Share this post