In Excel, a chart also referred to as a graph is used to graphically display data which can make it easier for the user to analyse and interpret.
In this tutorial, we will show you how to compare revenue figures for two different years using a line graph.
Video Guide
Instructions
- Firstly you will need to setup your data to be able to compare month to month revenue.
- Once you have setup your data you need to highlight all your data and then click ‘Insert’. From the Insert menu, we will then need to select the appropriate ‘Line Graph’.
- Now that the graph has been automatically generated, we can move and resize it to suit our preference.
- Once you have formatted the graph, we can now give the chart a title, you can do this simply by clicking on ‘Chart Title’ and renaming it. If you do not have a default chart title you can add this by clicking on ‘Add Chart Element’ -> Chart Title -> Above Chart.
- Now we can add Axis Titles by clicking on ‘Add Chart Element’ -> Axis Title -> Primary Horizontal or Primary Vertical. We can call the Horizontal axis Month and Vertical axis Revenue.
- Next, we need to edit the Legend title, the Legend is the name of the two lines that we will be comparing in this example these are the lines defining the year 2017 and 2018.
- To do this right click on the chart and then click select data and then rename the legend entries by clicking on the first legend entry and inputting 2017 into the ‘Name’ field and then doing the same for the 2nd
- Once this is done click ‘OK’ and you now have your completed chart.
Wow such a useful blog!
LikeLiked by 2 people
Great information. Thanks.
LikeLiked by 1 person
Very helpful article I enjoyed learning how to create a chart comparing two sets of data
Thank You for sharing
Jeff
LikeLiked by 1 person
You really do live up to your blogs name. Really easy to understand. Thank you
LikeLiked by 1 person
Simplified Comprehensive Information
LikeLike
That’s so lovely
LikeLike
Wow! You have covered some very useful topics in your blog!
LikeLiked by 2 people
Hello there, I found your blog via Google whilst searching for a comparable
matter, your site came up, it appears good. I have bookmarked it in my google bookmarks.
A lot of folks will probably be benefited from your writing.
Cheers!
LikeLiked by 1 person
I have to learn as as little kid. Good information. Thank you.
LikeLiked by 1 person
Good subject well furnished. I need to learn it technically, as I am a computer Zero, it will be a difficult job. Thanks a lot.
LikeLiked by 1 person
Thank you for sharing. I’ve never used Excel a lot but my girlfriend has used it plenty in her accounting classes. The video is very helpful. Excellent post!
LikeLiked by 1 person
Thank you so much
LikeLike
it’s awesome article.
LikeLike
I’ve been browsing online more than 2 hours today, yet I never found any interesting
article like yours. It’s pretty worth enough for me.
LikeLike
This is a nice article
LikeLike
Like button is not appearing on site. It indicates only ‘downloading’… Easy to learn some very good tips. Thanks!
LikeLike
THANKS SO MUCH FOR THESE CLEAR, USEFUL INSTRUCTIONS!
LikeLike
Good post. More people need to learn how to analyze data this way. 🙂
LikeLike
Good one .. I have message you earlier waiting for your reply
LikeLike
Pretty useful information share. Cheers.
LikeLike
Thank you! What is available on excel help hasn’t been sufficient. I’ve been able to kind of do it but I’m missing something. I am looking forward to digging into this more fully.
LikeLike
Thank you. Deon
LikeLike