Categories: Tech

How to Make Charts, Graphs in Microsoft Excel 2013, 2010, 2007

Microsoft Excel is a great tool for data handling, data processing and information showcasing. Millions of people, small business and Enterprise use Excel daily for a variety of reasons. MS Excel has its great nifty feature which lets you carve data and information into pictorial form. This way, you can quickly show your data in the graphs and charts for presentations and other purposes. Let’s see how to make charts in Excel. This tutorial will teach you how to make chart, graph in Excel 2010, 2007 and all other versions as there is not much difference in the options and tools of the Office versions.

Make Charts, Graphs in Excel

In order to make a graph or chart in Excel, you must have the data which you want to show in the graph. Select all the data from the mouse by clicking on the first row and first column, dragging the mouse to the last row and last column. The idea is to select the complete data set for which you want to draw the graph.

Click on the “Insert” option from the tool bar and you will see different types of charts in the charts section. You can select bar graph, line graph, pie chart, and many more.

You can also select the 3D chart option from the Insert chart option if you want to make a holistic 3D graph for the data. Ever chart has its 3D form in Microsoft Excel.

The type of chart is important. If the data is sparse and not well connected, pie chart is the best option. If you have stats and trends like scores and marks for different people or teams, you can select column chart. If you select any chart type and find out that this is not what you were looking for, you can click the “Change Chart Type” option from the top left corner of the screen and change the chart.

You can click the “Switch Row/Column” option to switch the information along axis.

If you want to revamp and tweak the looks of the chart, you can click the chart layout option from the tiny arrow button as show in the image below.

If you want to change the name/title of the chart and axis title, the name of the metrics appearing along X and Y axis, you can do so by double clicking the word “Chart Title” and “Axis Title”.

You can also decrease and increase the size of the information and chart. For example, if you made the chart on a data set and now you want to slash some data columns and rows and make an edited chart, you can just click, hold and add or delete the columns and rows and the chart will be edited accordingly. You can toy around with the chart data and interface to find out more functions.

This was how to make charts in Excel 2007,2010, 2013. If you face any problem in this tutorial of how to make graphs and charts in Excel, share them in the comments.

Images: UberGizmo

Fahad Saleem

Recent Posts

Bitcoin begins climbing into Positive Territory following massive drop as Regulators tighten the noose on Cryptocurrencies

The past few weeks have demonstrated yet again just what the heck a rollercoaster ride…

14 hours ago

How To Protect Yourself Online Against Phishing Using the New Password Alert By Google

The Internet has become a jungle, in the sense that it has become a feeding…

1 day ago

Underlying causes of Houston Motorcycle Accidents

Motorcyclists were 27 times more likely to die in motor vehicle accidents than passenger car…

2 days ago

6 Proven ways to Grow your Digital Marketing Agency

Starting a digital marketing agency is straightforward, but operating and transforming it into a successful…

2 days ago

Form and Function – A Workspace that Works

Photo by XPS on Unsplash We have all been in those drab offices - filled…

2 days ago

Why Implement Cloud Computing In Pharma?

The pharmaceutical industry is one of the most innovative and knowledge-intensive industries in the global…

2 days ago