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.
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.
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.
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 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:
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.
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.
Same way as for 2D data, select the data in this case too and click Insert > Column and select a chart type.
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.