Latest posts by techwriter (see all)
- INFOGRAPHICS – Which Business Entity is Right for You? - September 28, 2016
- 3 Ways to Add Copyright Free Images to Your Blogs, Books and Documents - September 19, 2016
- How to Delete All Hyperlinks in a MS #Word Document through VBA Macro - September 1, 2016
For many people spreadsheets can often be confusing and impenetrable wall of information. Charts are an easy and accessible way of displaying and viewing this data. Additionally, there are a wide variety charts or graphs that can be created for different uses!
Among the most popular graphs, particularly in the English speaking world, is the Pie Chart, which is best applied when explaining percentage, rendered in the form of a pie slice.
The other major charts are the Bar Graph which is used to show frequency or values for separate categories. The Histogram, which represents the quantity of points that fall within a numeric range and the Line Chart, which is a 2-D Scatter plot of observations where the observations are connected following their order. A Scatter plot uses coordinates to show the relation of two or more variables.
Other possible graphs are the Bubble Chart, which is fundamentally a 3 dimensional Scatter Plot. The Polar Area Diagram, which was developed by the legendary nurse Florence Nightingale, and is an enhanced form of Pie Chart.
You could also opt for the Box Plot graph that shows information about distribution (i.e. minimum, maximum and mean average) on a sole axis. As you may have gathered, there is an incredible array of charts that can be deployed according to your every information displaying need. All you have to do is choose the most appropriate one for the information you wish to show!
When creating graphs the Excel Chart Wizard is of tremendous benefit. The Wizard allows you to select data from your workbook cells and turn it into a fantastic chart of your choice! All you need to do is highlight the workbook data you would like represented and then select Insert [Chart] or click on the Chart Wizard button.
The next step is to choose what type of chart you would like your data to be represented as, then click and hold on the Press and hold to view sample button so you can preview how your chart will appear. The chosen data will appear in the Data Range box. From the series in option, select whether you want the data to be represented in rows or columns.
From this point you can alter your chart options, including the chart title, grid lines and axes. In most charts you would include a title both for the chart and the axes. If you are using a Pie Chart, you need to note that a Pie Chart is used to compare data within a single date range. Each piece of data is only a proportion of the total amount.