Featured Post

Complete Parts and Function of Computer Keyboard

BELOW ARE THE MOST PARTS AND FUNCTIONS OF THE COMPUTER KEYBOARD THAT COMMONLY USED. A computer keyboard is used to enter commands of...

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.   

No comments:

Post a Comment

Note: We have Zero Tolerance to Spam. Avoid Promotions with 'Links' considered as spam will be deleted immediately upon our review.

MAY YOU LIKE THIS POST!