Chart is a tool that is used by the excel experts in communicating data through graph. A long list of numbers in excel, becomes difficult to interpret, this is the reason that experts use graphs behind the numbers in the worksheet. These graphs show comparison of the trend and communicate the information a lot easily and effectively. You can make different types of chart on excel depending on the requirement of your company. Here are the few charts that are commonly used:
1. Column chart is simple and commonly used by excel programmer for displaying any kind of data. While making column chart you can use pyramids or any other 3-D style to represent the data.
2. Line chart is mostly used for showing the trend of your progress in the data. In this kind of a chart, usually points showing the trend are connected to lines, which show the number.
3. A pie chart quickly helps you to see and understand which value makes up the largest percentage. Excel programmers use pie chart basically to denote the proportion. The chart has a circle that is divided into portions depending on the value, the higher one occupies larger portion, whereas the smaller occupies less portion.
4. Bar chart looks the same as column chart, but in bar chart the pyramids are horizontal.
5. Area chart and line chart look similar, but in area chart few lines are filled with different color, this enables data to stand out better. The colored lines also help you in understanding the trend of one line in comparison to the other.
6. When the excel experts have a large volume of data, they usually use surface chart. Surface chart has three dimensional figures, which allows you to quickly find where the highest number is and where the lowest is.
You can prepare chart by selecting the cells from your spreadsheet to appear on chart. While selecting ensures that you select the entire source that needs to be added in the chart, which includes column title and row labels. Once the data is selected, click on the insert tab. Once the insert tab opens click of the desired chart in which you want to put in your data. Once the chart type is selected click ok, you will find that the chart is displayed on your worksheet. Once the chart is inserted, you can modify it as per your requirement, by using the chart tool.
Excel programmers can also change the type of their chart, after inserting it in your worksheet. To change the chart type, in the design tab, click on the change chart type option. Once you click, a dialog box will open, from where you can select the chart type and click ok. Chart can also be moved to a separate worksheet, by selecting the move chart option from the design tab. The dialog box usually opens in the current sheet, you need to select the new location and click the ok button in order to place the chart on a new sheet.
No comments:
Post a Comment