Create Graphs And Charts Quickly In MS Excel 2010

by Rohit Khurana on May 6, 2010

Advertisement

Charting or graphing of data makes it easier to understand a trend about presentation of data. Many of us need to create such graphs, charts or visual chars like pi-chart etc at times. Its often complicated to understand and create charts with conventional tools or softwares. Not anymore, with powerful features of Microsoft Office Excel 2010, charting and graphing has been extremely simplified.

create graphs and charts with MS Excel 2010

In this article I will demonstrate how you can quickly and easily create graphs and charts with MS Excel 2010 with ease. All you need is your data put in a table with which you need to create the chart. In this example, I will use some dummy sales data and will demonstrate the creation of 1-dimensional and 2 dimensional data. By 2-dimensional I mean the data with more than one rows and one column.

2D Data Chart Creation With MS Excel 2010

In this table, I have put some sales data for various months for various cities. Each column represents a month, each row represents sales for a particular city for that month. This is an example of 2D data.

2d-data-in-excel-sheet

To create a 2D chart out of this data, I just need two simple steps, Select all the data for charting with mouse cursor and click Insert > Column under the charts area at the top ribbon of MS Excel 2010.

select-data-in-excel-and-insert-chart

Chart is created in the blink of an eye ! Its really simple and fast. As soon as you click on the chart area, “Chart Tools” menu appears on the top ribbon of MS Excel.

chart-created-and-chart-options-appear

Chart Tools” menu  allows you to modify Design, layout and formatting of the chart and the table. You can see some minor tweaks I made to this chart:

Advertisement

switch-the-layout-of-the-chart-with-quick-layout

You can tweak many options related to the charts like layouts, formatting, design, chart type, displaying data, legends, color scheme etc.

In the Insert option in charting area, you can select other options line line graph, pie chart for different kind of representation of the data. Below is an example of the scatter chart of all the data on one graph.

2d-scatter-graph

There are many other option which you can try and experiment with.

1D Data Chart Creation With MS Excel 2010

In this table, I have put some sales data of one city for various months. Each column represents a month, the row represents sales for a particular city for that month. This is an example of 1D data.

1d-data-in-excel-sheet

Same way as for 2D data, select the data in this case too and click Insert > Column and select a chart type.

data-chart-created-1d-and-chart-options-appear

You can again use Chart Tools on this chart to modify its appearance as per your needs. In the Insert option in charting area, you can select other options line line graph, pie chart for different kind of representation of the data.

line-graph pie-chart

Above are some examples of 1-dimensional charts in MS Excel, line chart and pie-chart etc. Check out more tips on MS Excel and MS Office 2010.

If you like this article or this article helped you, you can +1 to recommend this article on google plus.

You can follow us on Twitter or join our Facebook Fan Page. If you have a question to ask us, submit your question at Answers By Trouble Fixers.

Looking for something else? Search here :

Leave a Comment

Previous post:

Next post:

© TroubleFixers – All about fixing computer troubles2007-2016 . All Rights Reserved.