Excel+Basic+Charts+and+their+Practical+Applications

//In business, you are frequently presented with the task of presenting data in a professional, effective, and well-organized manner. In order to be successful in the presentation of data, it is vital to use visual aids. These visual aids consist chiefly of graphs and charts, both of which can be quickly constructed in Excel. Below is an explanation of Excel's three basic graph/chart types (Line Graph, Bar Graph, Pie Chart), when they are most effective, and when they are least effective. This information will help you provide your audience with easily interpreted data. Information for the graphs/charts is// //sample revenue data from the years 2000-2011.//

//**A Line Graph,**// displays data by the use of one or more lines that are in correlation with the horizontal and vertical axis information provided. Line graphs are highly useful when showing changes/patterns in data over a specified period of time. When done correctly, this graph provides a clear and distinct visual. Due to the rise and fall of the lines, the viewer is able to interpret the data quickly and effectively.


 * //A Bar Graph//**, is best used to track drastic/specific changes. Minor changes can be easily lost in the visual aspect of the graph. Bar graphs can be useful in identifying specific data for a specific period of time. And example of this would be: If I want to see the amount of revenue for the year 2006, I can quickly and accurately say that it is 100,000 because each bar is distinctly assigned to a specific year. In the line graph, it is slightly more difficult to decipher the amount of revenue for a specific year/time period due to the visual construction of the graph.


 * //A Pie Chart//**, is good for showing the relationship between data, specifically in terms of quantity. A pie chart is not good for locating specific numeric data or interpreting the change in data. For example, the revenue data above is difficult to interpret and exact figures are impossible to conclude. It is clear that in 2008 there was more revenue than in 2000, but by how much is unable to be determined. The visual is helpful in comparing data but not in formulating solid numerical conclusion.

Want to see applied examples of business plan graphs? Copy and paste the html code below to see the practicality of graphs/charts and the benefits that they can have in the business world
 * ---> http://fast4cast.com/sample-graph.aspx <---**