Macros in excel 2010 tutorial pdf free download

Charts and graphs are a great way of representing your data. Microsoft Excel 2010 offers almost every chart type and makes macros in excel 2010 tutorial pdf free download easier to draw them so that your data can quickly understood in a graphical format.

In this post you will learn what each chart and graph represents and the additional functionality that you might not have heard about. How To Draw Charts In Excel 2010First 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 2010The 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.

The best example of this chart type can be the weekly change in temperature. It represents data in the form of a pie. Bar GraphA bar graph illustrates comparisons among individual items.

An area chart displays the magnitude of change over time. 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 ChartsA surface chart comes in handy if you are to determine the optimum combination between two sets of data. 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. 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.

scroll to top