The Five Knowledge Comparisons That Excel Charts Build

Charts enable you to visually compare knowledge in 5 basic ways that, that means that your initial step in determining the suitable chart kind is usually simply to think about what data comparison you would like to make.
Identifying the information comparison you wish to make
Suppose, for instance, that you have collected detailed product sales revenue data for a golf equipment manufacturer. Using a chart, you may decide to seem at this data in any of the ways summarized within the paragraphs that follow:
Half-to-whole Compares a private data point price to the add of a data series. Comparing
sales of a explicit golf club set to total sales, for instance, may be a half-to-whole comparison.
Whole-to-whole Compares individual data purpose values to every different or information series to every
other. Comparing sales of a starter men's golf club set to a starter girls's golf club set, for example, is a whole-to-whole comparison.
Time-series Compares knowledge point values from different time periods to show how values
amendment over time. Showing monthly sales over the past year, for instance, may be a time-series comparison.
Correlation Compares different data series to explore correlation between the information series.
Comparing business-wide sales to the average age of the population, as an example, is a correlation comparison.
Geographic Compares data values employing a geographic map. Comparing sales by country,
as an example, could be a geographic comparison.
Selecting the right chart for a given knowledge comparison
Once you decide what knowledge comparison you wish to create, it's typically quite easy
to spot the acceptable Excel chart varieties and generally even to identify appropriate
chart sub-types. Here are some rules you can follow:
1. To form a part-to-whole comparison when operating with simply a single data series, you
would possibly opt for a pie chart. (Pie charts plot only one data series.) You might choose a
doughnut chart or space chart if you're working with a lot of than one information series.
2. To form a whole-to-whole comparison, you might choose a chart that uses horizontal information markers, such as a bar chart or one in all the cylinder, cone, or pyramid chart sub-sorts that uses a vertical knowledge class axis and knowledge markers. You may also select a doughnut chart or radar chart.
3. To make a time-series comparison, you would sometimes opt for a chart that uses vertical knowledge markers, such as a column chart, a line chart, or one amongst the cylinder, cone, or pyramid chart sub-varieties that uses a horizontal data class axis and information markers. You may conjointly opt for the stock chart if you are performing technical analysis of security prices. (Time-series charts typically use a horizontal knowledge class axis as a result of of the Western convention of employing a horizontal axis to denote the passage of time.)
4. To create a correlation comparison, you may choose the XY (scatter) chart if you're operating with 2 data series or the bubble chart if you're working with three knowledge series. You would possibly additionally opt for the surface chart if you wish to explore trends in 2 dimensions.
5. To make a geographic comparison, you'd in all probability use Excel's Knowledge Map tool (ask the Excel on-line facilitate) or, probably, the surface chart.

Article Source: http://casinoarticles.us

Leslie Donner has been writing articles online for nearly 2 years now. Not only does this author specialize in westerns ,you can also check out his latest website about: Diamond Earrings Studs Which reviews and lists the best Natural Diamond Earring Studs

Please Rate this Article

5 out of 54 out of 53 out of 52 out of 51 out of 5 

Not yet Rated