What are some useful advanced Excel charts

8 types of Excel charts and graphs and when to use them

There's a presentation coming up in a few days and you really want to impress the boss. You want to present your data in a way that is easy to understand, but also visual and impressive. The only way to do this is by choosing the right chart for your data.

There are many different tools that you can use to create charts and graphs. How to create a graph from raw data files in any Office product. How to create a graph from raw data files in any Office product. It wouldn't be nice to just be able to open an Excel spreadsheet or Word document and read the data straight from a text without doing anything ... Read on, but Microsoft Excel remains one of the most powerful and powerful most functional of all. You can visualize data in any format and style you want, as you'll see below.

In this article, you will learn about the many types of charts available in Microsoft Excel using examples from publicly available data provided by data.gov. The dataset is from the 2010 US Census and is used to show how impressive it is when you pick the right chart for your data.

Make the right charts

The US government makes data available to the public free of charge. One of the most valuable pieces of information for searching cultural and social facts is the census.

For the first examples below, I've drawn tenant home issues broken down by the four regions of the United States.

This is a nice little subset of data that is easy to represent.

To decide which chart to use, you need to look carefully at what the data represents and how you want to visualize that data. Visualize your data and make your spreadsheets easy to use with an Excel dashboard. Visualize Your Data and Build Your Spreadsheets Ease of Use with an Excel Dashboard Sometimes a simple spreadsheet format is not enough to access your data. You can use a dashboard to present your most important data in a clear format. Continue reading .

Column charts

One of the most used diagrams in presentations 10 Powerpoint Tips to Prepare a Professional Presentation 10 Powerpoint Tips to Prepare a Professional Presentation Presentations are a great way to support a lecture. This guide will help you create presentations with a professional appearance and concise content. At the same time, you avoid the most common presentation mistakes. Read More and Dashboards Leftronic: Create a dashboard to monitor statistics and trends from different web services in one place Leftronic: Create a dashboard to monitor statistics and trends from different web services. In one place Read More Usually these are values ​​that have been categorized in some way. The most common subset for a column chart is a data set that is broken down into categories.

In this case, I've decided to reduce the number of problems renters in the northeastern US are experiencing. When you have selected your data, simply click on Insert, Various types of graphs are displayed in the menu. In this case, you can drive with a 2-D or 3-D pillar.

Personally, I prefer the look of 3-D charts. PowerPoint Art: Creating a 3-D Circle for a Cyclic Process PowerPoint Art: Creating a 3-D Circle for a Cyclic Process With each improved output of PowerPoint presenters have better tools to play with. So much so that you don't need a full-featured graphics editor to magically edit your slides. You can ... Read More This is what the above data looks like with 3D bar graphs.

Unfortunately, by default, charts are used with no vertical or horizontal labels. So you need to add these so that users know what the numbers mean. It's easy enough. Just click the "+" button in the top right corner of the graph Axis title is selected and then just select Primary vertical.

You will now see a vertical label that you can edit.

As you can see, you can use a column chart to visualize your data and make your spreadsheets easy to use with an Excel dashboard. Make your data visible and make your spreadsheets easy to use with an Excel dashboard. Sometimes a simple spreadsheet format is not attractive enough to make your data accessible. You can use a dashboard to present your most important data in a clear format. Read More Obviously, the people of the northeast are having huge problems with the installation and heating!

But how bad is that compared to the rest of the country? To show this, add more categorized data, use bar charts instead. Bar charts are the same as column charts, but the categories are displayed horizontally rather than vertically.

This time mark all the dates.

Now click on Insert In the menu, as before, click the bar charts drop-down menu to the right of the column charts drop-down menu.

Voilà! You now have a comparison of the reported problems of tenants for geographic areas in the US in a bar chart.

Pro tip: I had to edit the title as shown. To do this, just click the title and enter a new title, at least in Office 365. Other versions may require you to click Advanced editing.

As you can see, column charts and bar charts are a really great way to compare either categorized data for a data set or categorized data across multiple data sets. For example, the regional chart above shows quite clearly that the plumbing problems are much worse in the south and northeast, while the south is struggling a lot more than anyone else involved in property maintenance.

Pie charts

As the name suggests, pie charts are shaped like a circle. They are best used when you want to see the amount of a much larger category that is occupied by smaller sub-categories.

For example, a university may use a pie chart to show a breakdown of their students' racial demographics. Using our data above, you can use a pie chart to break down problems with the tenant in the northeast by repair problems.

This is another good chart to use when starting with data that has already been categorized. Pie charts are best used for a data set that is divided into categories. If you want to compare multiple data sets, it is best to use bar or column charts.

Line charts

A new record is required to get to line charts because line charts and other similar chart types are time dependent. This means that you usually (but not always) plot a data point over time.

This is not always the case. Ultimately, you only need an X and a Y value for a line chart. In the example below, X is time and Y is population. However, you can just as easily determine your company's productivity (Y) as the number of bonuses paid increases (X).

The census record we will be using in this example is for the population change of the United States from 2010 to 2015.

Highlight the Year and Total Population columns, then click Insert Select a line chart and select a line chart that appears in your table. Right-click the chart and choose Select data source. Make sure the year is not selected.

Since no attempt is now made to use the year column as Y, it is used as X and the horizontal axis is labeled correctly.

At a glance, you can see that the US population has been growing steadily at a rate of about 0.76% per year. This is the kind of thing that line charts show.

Area charts

Area charts are the same as line charts, but the area below the line is filled. However, the focus of the line chart remains change In the case of time values, the focus of an area chart is on emphasizing the size of the values ​​over time. The difference is slight, but when you need to show things like how many trees were felled between 1990 and 1995 compared to 2000-2005, the area chart really shines.

Using the population data above, you can compare the population growth of men and women from 2010 to 2015.

You can also display the same data with a stacked area chart (also available in the chart area under Insert Menu).

This chart can be thought of as a line chart and a pie chart on a chart. You will see the percentage breakdown of the categorized data as that data changes over time.

Because the change is so small over the five years outlined above, one cannot quite make out the fact that while the female population is about 3% larger than the male population, the male population is actually growing about 3% faster each year Population of US Women As If Dating Wasn't Hard Enough Online Dating: Men Don't Get It And Women Don't Understand Online Dating: Men Don't Get It And Women Don't Understand Online Dating Websites Work? It's time for an open discussion! What I learned from interviews was that online dating is equally painful for both men and women, but for very different reasons. Read More

Scatter Diagrams (XY)

A popular point among scientists and statisticians is scatterplots of plotted data points (usually a group of similarly measured data points) that are designed to show correlations or patterns in the data that are not obvious if you just look at individual data points.

For example, planning cancer recovery success rates versus time spent in hospital may show a correlation between a person's length of treatment for cancer and the likely success of the treatment.

To show the power of this chart, I have recorded the number of asthma hospital stays in Chicago from 2000 to 2011, sorted by zip code.

This XY scatter plot (also known as a “cluster” chart) shows that zip code 60628 had more asthma hospital admissions per year than almost any other region, and zip codes 60655 and above make the best neighborhoods if you have the fewest possible chance for one Want to have hospitalization with asthma.

Bubble chart

This can also (even better) be represented in the form of a Bubble chart. This is a fun visualization that can be created when you have three dimensions of data to plot.

This is a typical XY data point of two values ​​(the point is a “bubble”), with an additional combined value that determines the size of that bubble. For example, you can use this type of graph to show how many teenagers go to the movies. However, the size of each data point (bubble) can mean how many women make up that data set.

It's a very interesting way of showing two sets of data on one chart. In the example above, if you put the name of the movies as the label for the x-axis, you can find that of all the movies the teenagers were on for which certain movies attracted larger teenage female audiences.

Surface diagrams

Just when you thought there couldn't possibly be more charts available, here are surface charts. You can use this three-dimensional chart to plot two series of data points across multiple dimensions. It can be complex to use, but with the right data points (two series with a clear relationship) the visualization can be quite impressive.

The 3D version of the diagram looks like a topographic map. This makes sense because such a map is a graph of the elevation and distance from a given point. Similarly, you can use this card, for example, to determine the extent of an outbreak based on the person's age and time of illness.

Drawing in this way can create interesting patterns that you would never notice if you just draw two points along a simple X-Y axis.

Donut charts

Donut charts are another complex visualization. 4 data visualization tools for fascinating data journalism. 4 data visualization tools for fascinating data journalism. Words and numbers are not enough. In the end, visuals catch and convince your viewers. Here are the tools that will help you make something great out of your data. More information, with which you can format a data series in a kind of pie chart, but also additional data series in “layers”, forming a colorful “donut”. This is best used when the two data series are subcategories of a larger data category.

A good example of this is the datasets used earlier in this article, which show the male and female populations per year.

As you can see, each series (the years 2010 to 2015) contains nearly identical segments, showing how slowly both populations change from year to year. The value of this chart comes from having the right data and the right goal that you want to visually accomplish with that data.

Choosing the right graph

That really is the point of all of this. While there is a nice selection of charts that you can use should Really choose the type of dataset you have available and exactly what you are trying to show (or prove) with that data. Some charts make your point of view much clearer than others.

Knowing which graphic will do that is half the battle. The other half tells you exactly how to arrange your data and format the chart the way you want.

The truth is, charts make a huge impact in any presentation. 5 PowerPoint Tips To Improve Your Presentation Skills Overnight 5 PowerPoint Tips To Improve Your Presentation Skills Overnight You step onto the podium. Your palms are sweaty, your heart is racing, and just as you are about to open your mouth and speak, your mind goes blank. Need help? Continue reading . Now that you know everything available in Microsoft Excel, choose the right chart for your needs and create a presentation that is really daunting.

Learn more about: Microsoft Excel, visualizations.