“A good sketch is better than a long speech” - Napoleon Bonaparte
A picture is worth a thousand words... In the age of Instagram and Snapchat, visuals are important. A simple graph can explain the whole concept. That's why using Excel to create graphs can be very useful.
However, while younger generations are masters of social media and using smartphones, some still have a few things to learn when it comes to the Microsoft Office suite. 19% of us according to CSA Research.
In this article, we're going to have a look at which type of chart you should use to represent your data, how to organise data in a graph, how to change the formatting, and how to export your new chart into other programmes.
Which Graph Should You Create on Excel?
Excel is part of the Microsoft Office suite, a powerful set of tools for computer users. Excel allows you to organise data and perform calculations on them.
The programme is famous for being used to create spreadsheets, tables, and graphs. It’s quite a mathematical tool and its use is taught to schoolchildren.
That said, if you don’t use it, you’ll quickly forget how to use it even though creating a chart in Excel is quite simple.
Before you create a graph, you need to know which chart types are the best for displaying your data:
- Column chart: this is a graph with vertical bars allowing you to compare sets of data. This is useful for comparing two values and seeing the difference between them on the vertical axis.
- Line Chart: The line graph uses straight or curved lines to show a trend or progression.
Pie chart: This displays one series of data. If can show you proportions of data.
- Stacked chart: this puts series into columns on top of one another.
- Bubbles: this shows the relationships between several values.
- Bar chart: This is just like your column chart but with data expressed on the horizontal axis.
- Scatter graph: The scatter chart is a type of graph that plots each data point is plotted in a given position on the x-axis and y-axis.
- Histogram: This is a column chart that shows frequency data.
You need to choose each graph in accordance with the type of data you’re presenting. Charts and graphs are only effective if they clearly display the information from your data table.
Microsoft Excel has some powerful chart tools but if you use a bar graph to display Excel data that expresses a change over time, people will think you're an amateur.
Find out more about using logical operators in Excel.
Organising Data into a Graph
Like with spreadsheets, when you create a graph, you need to organise the data correctly so that the programme knows what you want to do.
Firstly, choose the type of data you want to be shown in your graph and give them a title in the first row of the spreadsheet.
If your graph is going to show the number of members in a group, you could write “Volunteers” in B1 and “Paid Members” in C1.
Column A will be used for time. You could write “1950” in A2 and “1960” in A3, etc. This will give your axes labels.
Once you’ve got the groups set up, you can start putting the data into the columns. You don’t need to compare the two columns to one another. You might just choose one column and have a simpler graph.
To create a pie chart, it’s even simpler. You can just provide one series of data and the programme will create the segments.
- Paid Employees: 23
- Volunteers: 110
Excel will work out the percentages for creating the graph.
Creating the Graph in Excel
Once all your data is in your spreadsheet in Excel, you just need to follow the steps to create a graph. This doesn’t take much time. The most time-consuming activity if getting your data into the spreadsheet. Once you've filled your rows and columns with data, it's very easy to create graphs in Excel.
You need to choose the cells with the data from your Excel spreadsheet.
Click on the cell at the top left of your data, hold down “shift”, and then click on the bottom right cell. This will select all your data.
You can do this by dragging by holding down the left mouse button as you click on the top left cell and dragging down to the bottom right one.
You then need to go to the “Insert” tab on the toolbar. New elements will appear in the toolbar.
In the “Charts” section, you can choose the type of graph you want to make. There’s also a “Recommended Charts”.
The small arrows next to each type of chart allow you to see what it’d look like before creating it. You can do this by hovering the mouse cursor over it.
You just have to click and the graph will be created in your spreadsheet.
Now you can give your graph a title by clicking on the text above the graph.
Check the different IT classes on Superprof.
Changing the Formatting of an Excel Graph
Your graph is now ready.
But how do you change it once you’ve made it?
You just need to click on the graph and go to the “design” tab that shows up when you select it. In the new toolbar, you can edit the visuals of your graph.
You can alter things such as:
- The axes
- The title of the axes
- The title of the chart
- The labels
- The graph
- The legend
It’s a good idea to include a legend so that people can understand your graph. Something that may seem obvious to you may not be as obvious to somebody else.
Exporting the Graph from Excel
To use your graph outside of the spreadsheet, you’ll need to save or export it.
Exporting the Graph to Microsoft Word
It couldn’t be simpler putting your graph into word processing software like Word. You just need to select the graph, right click, then copy and paste the graph into Microsoft Word. This allows you to put the graph next to text.
Saving the Graph as a PDF
To save as a PDF, you need to go to “File”, then “Save as...” and choose the .PDF formate.
Saving the Graph as a JPG
In order to save the graph as an image file, you can copy and paste the graph into Pain and save it as a JPG there.
If you want to use Excel more efficiently, consider learning some keyboard shortcuts.
What Are Excel Graphs For?
Excel graphs are useful for displaying information in an easy-to-understand way. Excel graphs are useful for displaying information in both our professional and personal lives.
You can use graphs to visualise data.
You can compare expenses, for example. As you’ll have understood, you can transform data into charts in Excel. Excel charts are fantastic ways to display data. Give it a go and you'll soon learn how to excel with Excel!
If you want to learn more about using Excel or computers in general, you should get help from a private tutor. On Superprof, there are plenty of skilled and qualified private tutors ready to offer you tailored lessons.
There are three types of tutorial on the platform: face-to-face tutorials, online tutorials, and group tutorials.
Face-to-face tutorials take place with just one student. This means that the tutor's entire focus is on their one student and the lessons are planned with them in mind. While these tutorials are often the most expensive, they're also the most effective.
Online tutorials are similar but rather than the tutor being in the room with their student, they teach them using video conferencing software such as Skype. Since the tutor doesn't need to travel or bring physical resources with them, they can charge less per hour of tuition. This is also a great option for those who live rurally.
Finally, there are group tutorials. Group tutorials include several students and work out cheaper per student since the cost of tuition is shared amongst all the attendees. However, this does mean that you won't get as much one-on-one tuition from your tutor and the lessons won't be as tailored to your needs as the other two types.
Don't forget that the first hour of tuition is often offered for free. This is a great opportunity to try out different tutors, see if you get on well with them, and make sure that their teaching approaches are right for you before you commit to several lessons with them.