Microsoft Office Excel is one of the most widely used Spreadsheet programs across the globe and many major organisations use it. The main reason as to why it is used by so many people is because of the fact that it can process a large range of scales and numbers.
The most popular industries that make use of this software is that of the banking, finance, stats sales and just about any other business where large amounts of data need to be analysed.
Graphs on Excel
We all know that graphs are essential components when it comes to business statistics and using them it’s a whole lot easier to convey our message. It’s not always easy to ascertain data when it’s put forward to us in the form of tables, but the moment we see a graph we figure out what it all represents with ease.
Microsoft Excel has a wide range of graphs that you could employ and they’re all created with a few clicks – there’s not much that you need to do other than filling the columns and rows with the necessary information. Therefore, it’s a snap to create these graphs!
In case you’re creating graphs of your business profits it would be wise to use a line graph whereas if you’re graph is going to be on market share a pie chart would work best. There are also bar graphs that you could use for yearly growth statistics. Therefore, when you actually take a look at the options available you would realize that they’re amazing.
Creating a graph in Excel
Creating a graph in excel is really easy and all you need to do is follow the steps below:
- First and foremost open up a spread sheet and fill in the necessary information or you could just open up a saved document.
- Next you would need to highlight (select) the data that you want to see on the graph by dragging over the data with your mouse (you would already be familiar with these basic steps)
- Try and not include totals in the data as then your graphs would look odd as the total is definitely going to give your graph a high point thereby making the other points fall really close to each other.
- Include the necessary labels on your columns and rows as you would want to see on the final graph.
- In the versions before 2007 you had to go to the insert menu and then choose chart. However, in the post 2007 excel versions all you have to do is go to the insert tab and click on the appropriate graph format that you need.
But everyone’s favourite is the F11 key as it’s a shortcut to create a graph!
Hannah works with a company offering Excel 2013 training online. In addtion, she is also a certified Quickbooks trainer and conducts training classes across US.