how to draw graphs by EXCEL

[meidimu sirkon]

I don,t know how draw two or three graph by using the same source of information

 

[Hardman]

I don,t know how draw two or three graph by using the same source of information

here we go ....highlight the vertical axis data... then go to toolbars and menus select "charts" then draw the type of graph you want (column,line, pie ,bar n others...) by clicking it

 

[Maswi]

I don,t know how draw two or three graph by using the same source of information

nenda short course za IT

 

[SMU]

I don,t know how draw two or three graph by using the same source of information

Sijakuelewa. Unaweza kuweka mfano wa hizo info unazotaka kutengenezea graph? Unaweza kuelezea kwa kutumia kiswahili (au 'kiswanglish')pia tukakuelewa kirahisi zaidi.

 

[Maswi]

nenda short course za IT

but naweza kukusaidia,
First of all make sure that there is some data in your excel sheet and that your excel sheet does not contain any blank cells between the different columns, then click the Insert menu and choose the chart type that you wish to draw.

​

The data in your Excel sheet will be organized as a chart.

​

Once the chart is drawn, it becomes very easy to change the attributes, right-click the chart and you will see the options for changing chart types, data, and other formatting.​

​

[h=3]Chart and Graphs Types In Excel 2010[/h] The chart or graph type will depend on the data for which you are going to plot the chart. The most commonly used types include Column Chart, Line Graphs, Pie Chart, Bar Graph, Area Chart, Scatter Graphs, Stock Chart, and Surface Chart, among many others. Lets discuss these chart types, and the situations in which a specific chart type is used.
[h=3]Column Chart[/h] The Column chart is one of the most commonly used chart type and is used to show the changes in data over a period of time or illustrate comparisons among items.

[h=3]Line Graphs[/h] Line Graphs are mainly used to plot changes in data over time. The best example of this chart type can be the weekly change in temperature.

[h=3]Pie Chart[/h] The Pie Chart is very useful when you wish to emphasize on a significant element in the data. It represents data in the form of a pie.
[h=3]

Bar Graph[/h] A bar graph illustrates comparisons among individual items.
[h=3]

[/h] [h=3]Area Chart[/h] An area chart displays the magnitude of change over time.

[h=3]Scatter Graphs[/h] The Scatter Graph and Line chart are almost similar, but the scatter graph is displayed with a scribble line whereas the line graph uses connected lines to display data.
[h=3]

[/h] [h=3]Surface Charts[/h] A surface chart comes in handy if you are to determine the optimum combination between two sets of data.

[h=3]Chart Plot Area[/h] The area that is covered by a specific chart is called the chart plot area. By default Excel draws charts according to the default configuration, but its very easy to edit the plot area, simply right-click the chart and choose the Format Plot Area option. Now you will see a dialogue box which lets you set the chart's fill style, borders, Glow and soft Edges, and 3-D effects.

​

[h=3]Embedded Charts and Chart Sheets[/h] You can create a chart on it's own chart sheet or on a worksheet. In both ways the chart is linked to the source data on the worksheet, which means the chart is updated when you update the worksheet data. In order to set the chart to change while the values of some particular cells changes, right-click the chart and choose the Select Data option, and then select, and add the fields that you wish to include in this process.

​

 

[Maswi]

but naweza kukusaidia,
First of all make sure that there is some data in your excel sheet and that your excel sheet does not contain any blank cells between the different columns, then click the Insert menu and choose the chart type that you wish to draw.

​

The data in your Excel sheet will be organized as a chart.

​

Once the chart is drawn, it becomes very easy to change the attributes, right-click the chart and you will see the options for changing chart types, data, and other formatting.​

​

Chart and Graphs Types In Excel 2010

The chart or graph type will depend on the data for which you are going to plot the chart. The most commonly used types include Column Chart, Line Graphs, Pie Chart, Bar Graph, Area Chart, Scatter Graphs, Stock Chart, and Surface Chart, among many others. Lets discuss these chart types, and the situations in which a specific chart type is used.
Column Chart

The Column chart is one of the most commonly used chart type and is used to show the changes in data over a period of time or illustrate comparisons among items.

Line Graphs

Line Graphs are mainly used to plot changes in data over time. The best example of this chart type can be the weekly change in temperature.

Pie Chart

The Pie Chart is very useful when you wish to emphasize on a significant element in the data. It represents data in the form of a pie.

Bar Graph

A bar graph illustrates comparisons among individual items.

Area Chart

An area chart displays the magnitude of change over time.

Scatter Graphs

The Scatter Graph and Line chart are almost similar, but the scatter graph is displayed with a scribble line whereas the line graph uses connected lines to display data.

Surface Charts

A surface chart comes in handy if you are to determine the optimum combination between two sets of data.

Chart Plot Area

The area that is covered by a specific chart is called the chart plot area. By default Excel draws charts according to the default configuration, but its very easy to edit the plot area, simply right-click the chart and choose the Format Plot Area option. Now you will see a dialogue box which lets you set the chart's fill style, borders, Glow and soft Edges, and 3-D effects.

​

Embedded Charts and Chart Sheets

You can create a chart on it's own chart sheet or on a worksheet. In both ways the chart is linked to the source data on the worksheet, which means the chart is updated when you update the worksheet data. In order to set the chart to change while the values of some particular cells changes, right-click the chart and choose the Select Data option, and then select, and add the fields that you wish to include in this process.

​

kama usipoelewa hapo chuku link ya MWALIMU hapa, ila siku nyingine uwe unaumiza kichwa hata kusearch tu utapata kila kitu link VideoExcel - How to create graphs or charts in Excel 2010 (Charts 101) - YouTube