How to Create Chart or Graph in Microsoft Office Excel 2010

In Microsoft Excel 2010 you can create a stunning chart or graph of your data in a worksheet in a graphical manner. Rather than seeing the number, this is to easily understand what are the data and how it is being calculated inside a worksheet.

To bring more understanding using this application, Microsoft Excel chart compose of different chart formats. These are the bar, column, Pie, line, area, scatter, stock, doughnut, bubble, and raddar. These are powerful tool use for comparison, monitoring, and statistical data. 

Below are data examples inside a worksheets with chart applied:

1. Monitoring Product Volume Per Year Using 3D Column


MS_Excel_Worksheets

Highlight data inside your worksheet table/then click insert menu at the top/click column under the chart ribbon group/ then select 3d column on the list

2. Monitoring Product Volume Per Year Using 3-D Line Graph

MS_Excel_Worksheets

Highlight data inside your worksheet table/then click insert menu at the top/click column under the chart ribbon group/ then select 3-d Line on the list

3. Monitoring Product Volume Per Year Using 3-D Area Graph

MS_Excel_Worksheets

Highlight data inside your worksheet table/then click insert menu at the top/click column under the chart ribbon group/ then select 3-d area graph on the list

4. Monitoring Product Volume Per Year Using 3-D Bar Graph

MS_Excel_Worksheets

Highlight data inside your worksheet table/then click insert menu at the top/click column under the chart ribbon group/ then select 3-d bar graph on the list


5. Monitoring Product Volume Per Year Using Pie Graph

MS_Excel_Worksheets


Highlight data inside your worksheet table/then click insert menu at the top/click column under the chart ribbon group/ then select pie graph on the list


Other chart or graph is found in the same menu using Insert then other charts. You can use either stock, surface, doughnut, bubble, and radar.

In using this graph it depends on the data you want to view using chart or graph. If you want to monitor the up and down of a stock or your data in every month in everyday basis. Use the stock graph to monitor even in every hour of a day. Construct your worksheets, data of what you want to view.   
How to Create Chart or Graph in Microsoft Office Excel 2010 Arnel Cartoneros 5 of 5
In Microsoft Excel 2010 you can create a stunning chart or graph of your data in a worksheet in a graphical manner. Rather than seeing the...
Share on Google Plus

About Arnel Cartoneros

Arnel is a Blog creator and writer, A founder and publisher of www.combinebasic.com and www.nuggetro.info. Part time Computer Instructor, Computer And Electronic Technician, And performing job as Biomedical Machine Specialist. I'm an avid fan of social media and very interested in Technical information and innovation.