INTRODUCTION
In Microsoft Excel, you can represent numbers in a chart. You can create different type of charts using Excel 2013 that will help you to analyze data in a worksheet and give you a visual presentation of results. You can even customize the chart by adding text, arrow, title and legends etc. On the INSERT TAB you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter what type of chat you choose. As you change your data, your chat will automatically update.
HOW TO CREATE A CHART?
You select a chart type by choosing an option from the insert tab's chart group. After you choose a chart type, such as column, line, or bar you choose a chart sub-type.
CREATING A CHART
When you create a chart, chart tools become available and the design, Layout and Format tabs are displayed. In excel charts are visual representation of data on a spreadsheet.
To create a chart, do this:-
√. Select the data items you want to appear as a chart.
√. Under the insert tab, in charts group, click arrow next to that chart which you want to insert and then select the chart from the chart subtype.
√. Chart will appear.
For Example:-
In Microsoft Excel, you can represent numbers in a chart. You can create different type of charts using Excel 2013 that will help you to analyze data in a worksheet and give you a visual presentation of results. You can even customize the chart by adding text, arrow, title and legends etc. On the INSERT TAB you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter what type of chat you choose. As you change your data, your chat will automatically update.
HOW TO CREATE A CHART?
You select a chart type by choosing an option from the insert tab's chart group. After you choose a chart type, such as column, line, or bar you choose a chart sub-type.
CREATING A CHART
When you create a chart, chart tools become available and the design, Layout and Format tabs are displayed. In excel charts are visual representation of data on a spreadsheet.
To create a chart, do this:-
√. Select the data items you want to appear as a chart.
√. Under the insert tab, in charts group, click arrow next to that chart which you want to insert and then select the chart from the chart subtype.
√. Chart will appear.
For Example:-
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
2 Comments
Click here for Commentsvery nice ,
ReplyEasy-to-follow tutorial, I appreciate your efforts in writing this. As someone working everyday with excel sheets, never knew about construction of graphs in excel. Interesting feature. office.com/setup.
ReplyConversionConversion EmoticonEmoticon