In all older versions of Excel, analysts had to create a custom workaround using stacked column charts. In Excel 2016, Microsoft finally introduced a waterfall chart feature. The scatterplot is great for showing what a distribution of data points looks like and drawing a line of best fit for regression analysis. The scatterplot is excellent for showing the relationship between two data series and determining their correlation. The most common example is dollars on one axis and percentage on the other axis. This is very useful when presenting two data series with a very different scale and might be expressed in different units.

The above two types of graphs can be combined to create a combo chart with bars and lines. Source: Dashboards and Data Presentation course Bar charts have a much heavier weight than line graphs do, so they really emphasize a point and stand out on the page.

Highlight each single series with a different colorīars (or columns) are the best types of graphs for presenting a single data series.

Since line graphs are very lightweight (they only consist of lines, as opposed to more complex chart types, as shown below), they are great for a minimalistic look. This is the perfect solution for showing multiple series of closely related series of data. You can add some conditional formatting to the pie charts like I did to make it nice.The most common, simplest, and classic type of chart graph is the line graph.

There is no step 6, so go ahead and show off this cool table to your colleagues, make their jaws drop in awe.

Finally change the font to “pie charts for maps” from font dialog.

Enter a formula like =CHAR(CODE('a') + ROUND(data cell*21,1)), just replace the data cell with actual cell code.

Open excel, go to your data table and insert a column where you want incell pie charts.

Install the font (just extract the zip file, copy the font file to your fonts folder, click here to learn how to install a font in windows).The font has 21 pie chart codes starting with empty circle (character ‘a’) and ending with full circle (character ‘u’) Download free pie chart font from here ( direct download link).Here is a ridiculously easy trick to do nice incell pie charts in excel, what more, they will make you look like a charting wizard.

Make a pie chart in excel mobile