what would be a situation in which you could use an excel chart to present your data
Yous've got a presentation due in a few days and you really want to impress the boss. You lot want to show your data in a fashion that's easy to understand, but besides visual and impressive. The all-time mode to do that is to choose the right Excel charts and graphs.
Y'all tin draw upon many different tools for creating charts and graphs, but Microsoft Excel remains one of the most powerful and functional of them all. It allows you to visualize data in whatsoever format and fashion you want, as you'll see beneath.
In this article, you'll learn about the many types of charts available to y'all in Microsoft Excel using examples from publicly available data provided by data.gov. The data set is fatigued from the 2010 US Census; nosotros'll use this data to show you how impressive it is when you choice the right Excel chart types for your data.
Creating the Right Excel Chart Types
The US Government provides volumes of data to the public annually, completely free to peruse. I of the most valuable bodies of information to larn more than nearly cultural and social facts is the Demography.
For the commencement few examples below, I've referred to bug that renters have had with their dwellings, split up by the four regions of the U.s..
This is a nice, modest subset of data, perfect for learning about Excel charts and graphs.
In order to make up one's mind which chart to use, you'll need to accept a close wait at what the information represents and how y'all want to visualize that data.
ane. Excel Column Charts
1 of the most common charts used in presentations, cavalcade charts are used to compare values to one some other. Commonly, these are values that have been categorized in some way. The most common subset of column charts is one fix of data broken upwards into categories.
In this case, I've called to break it downward by the number of issues renters take in the Northeast United States. Once you've selected your data, but click Insert, and yous'll run across a choice of nautical chart types in the card. In this example, y'all tin become with a 2-D or three-D column.
Personally, I prefer the look of iii-D charts. Here'due south what the information to a higher place looks similar using 3-D bar charts.
Unfortunately, bar graphs are created by default without whatsoever vertical or horizontal labels. You'll need to add those in so people know what each axis represents.
Doing that is like shooting fish in a barrel enough. Just click the "+" push button to the upper right corner of the chart, make certain Axis Titles is selected, and then simply select Primary Vertical.
Now, y'all'll see a vertical label that you can edit.
As yous can see, using a column nautical chart to visualize categorized data makes the inequity beingness illustrated clear as day to see. Obviously, people in the Northeast have major plumbing and heating problems. How bad is the trouble compared to the rest of the land?
To investigate this divergence, let's add more categorized information using bar charts instead. Bar charts are the same as column charts, but the categories appear horizontally rather than vertically.
This time, highlight all the data.
At present, click Insert in the menu above, just like you did earlier. This time, click on the dropdown for bar charts, just to the right of the column charts dropdown.
At that place y'all have it. You now have a bar nautical chart comparison of reported problems by renters, broken down past geographic region.
I had to edit the title every bit shown. You practice this simply by clicking on the championship itself and typing a new title, at least in Microsoft 365. In other versions, you may need to click Advanced Edit.
As y'all can see, cavalcade charts and bar charts are a really absurd style to either compare categorized information for ane data set up, or to compare categorized data across multiple data sets. For example, the regional chart above shows quite conspicuously that plumbing problems are much worse in the S and the Northeast, while the Southward struggles a lot more than anyone else with property upkeep.
two. Excel Pie Charts
As the proper name implies, pie charts are shaped similar a pie. They're best used when you need to prove how much of i ascendant, overarching category is taken upward by smaller sub-categories.
For example, a university may utilize a pie chart to show a breakdown of the racial demographics of its student population. Using our information above, you might use a pie chart to break Northeast renter problems down by repair bug.
Pie graphs are some of the best Excel chart types to use when you're starting out with categorized data. With that being said, even so, pie charts are best used for one unmarried data set that'south broken downwardly into categories. If you want to compare multiple data sets, it's best to stick with bar or column charts.
iii. Excel Line Charts
Moving on to line charts requires a new set up of data. This is because line charts and other similar chart types tend to be time-dependent. You're usually charting a data point as it changes over a given period of time, although non always.
For a line chart, you only need an X and a Y value. In the example beneath, X will be time and Y will be population. You could simply as easily nautical chart other time-dependent variables, such as the productivity of your company (Y) as the number of bonuses paid goes upwards (Ten).
The census data set that we'll utilise in this example represents the change in population of the United States from 2010 through 2015.
Highlighting the year and the total population columns and then clicking Insert from the menu higher up allows you to choose a line chart graph. Selecting this option results in a line nautical chart in your spreadsheet. Right-click on the chart and choose Select Data Source. Brand certain that the Year is unselected.
Now that information technology's non trying to utilize the Twelvemonth column every bit Y, it'll employ it as X and correctly label your horizontal centrality.
At just a glance, y'all can see that the population of the US has been steadily increasing at a rate of about 0.76% per year. Very interesting, and line charts are some of the all-time Excel graphs and charts to utilize when conveying a progression like this.
4. Excel Surface area Charts
Area charts are identical to line charts, but the area under the line is filled in. While the focus of the line nautical chart is however changing in value over fourth dimension, the purpose of an area chart is to highlight the magnitude of these changing values over fourth dimension.
The difference is subtle, but when you need to express things similar how many trees have been clear cut from 1990 to 1995 versus 2000 to 2005, the expanse chart really is one of the all-time Excel chart types to utilise.
With the population data above, you tin compare things like male versus female population growth from 2010 through 2015.
You lot could too represent the same data using a stacked area chart (also available in the charts department under the Insert card).
This nautical chart tin exist thought of as a line graph and a pie nautical chart combined into one. You tin see the percentage breakdown of the categorized data as that data changes over time.
5. Excel Besprinkle (XY) Charts
A favorite in the scientific community, scatter charts are plotted data points, usually highlighting a clustered anomaly amongst similarly-measured data points or a far-reaching outlier. They're used to evidence correlations or patterns in the data that aren't obvious when you lot're just looking at each individual datum.
For example, plotting cancer recovery success rates against fourth dimension spent in the hospital may show a correlation betwixt how long someone is treated for cancer and how successful the treatment is likely to be.
To show the ability of this chart type, I've plotted the number of asthma hospitalizations in Chicago from 2000 through 2011, organized by zip code.
This XY besprinkle chart reveals that naught lawmaking 60628 had more than asthma hospitalizations per year than just about every other region, and zero codes 60655 and over make up the best areas to live if yous want the least possible odds of having an asthma hospitalization.
half dozen. Excel Chimera Charts
Chimera charts are likewise extremely useful for information sets like this. This is a fun visualization to create when you have three dimensions of data that you demand to plot.
This is a typical XY plotted data bespeak of two values (the point being a "bubble"), with a combined boosted value that determines the size of that bubble. For example, with this kind of chart, you could plot how many teens get to the movies, but the size of each data indicate (bubble) may correspond how many females make upwards that data set.
It's a really interesting mode to stand for two sets of data with 1 chart. In the instance higher up, if you included the name of the movies every bit the X-axis labels, you lot could place which, of all of the movies listed, attracted a larger teen female audition.
vii. Excel Surface Charts
These 3-dimensional Excel chart types let yous plot two sets of data points across several dimensions. It can be complex to use, only, with the right data points (IE, 2 sets of data with a clear relationship), the visualization can be quite impressive.
The iii-D version of the nautical chart looks like a topographic map, plotting altitude and distance from whatsoever given signal. Similarly, you can use this map to do things like nautical chart the severity of a disease outbreak against age and the fourth dimension that the person remains sick.
By plotting in this way, interesting patterns might become self-evident, things that you'd never notice otherwise. Knowledge is power.
8. Excel Doughnut Charts
Doughnut charts are some other complex visualization that lets you graph 1 data series in a sort of pie chart format. You tin add boosted data sets in "layers", resulting in a multicolored "doughnut". These Excel chart types are all-time used when the two data sets are subcategories of a larger category of data.
A good instance of this are the information sets used before in this article, plotting male person and female population per year.
As y'all can encounter, every serial (the years 2010 through 2015) contains nearly identical-sized segments, showing simply how slowly both populations modify from year to yr. The value of this graph really comes from having the right data and the correct goal that you want to achieve visually with that data.
Choosing the Right Excel Charts and Graphs
At that place may be a broad selection of graphs to use, but what you should actually choose really boils down to the type of information sets you're working with and simply what exactly it is that you're trying to show or evidence with that data. Some Excel charts and graphs will make your argument much clearer than others.
Knowing what the nautical chart needs to accomplish is half of the battle. The other half is figuring out exactly how to accommodate your data and format the chart.
The truth is that graphs make a huge impact on any presentation. Now that y'all know how to employ everything that'south available to you lot in Microsoft Excel, choosing the right Excel graphs and charts for your needs will exist easy. Yous'll be able to create a presentation with them that'll really knock their socks off.
About The Writer
Source: https://www.makeuseof.com/the-best-excel-charts-and-graphs/
Post a Comment for "what would be a situation in which you could use an excel chart to present your data"