# Excel Charts

## Sparklines in Excel: how to create, use and change

Looking for a way to visualize a large volume of data in a little space? Sparklines are a quick and elegant solution. These mini-charts are specially designed to show data trends inside a single cell. Continue reading

## How to add vertical line to Excel chart: scatter plot, bar chart and line graph

Even in the modern versions of Excel, there is no easy way to insert a vertical line in a chart. However, "no easy way" does not mean no way at all. We will just have to do a little lateral thinking! Continue reading

## How to add error bars in Excel: standard and custom

Scientists love quantifying different things, and they even found a way to quantify uncertainty. For this, they calculate confidence intervals, or margins of error, and display them by using error bars. Continue reading

## Excel trendline types, equations and formulas

It is very easy to add a trendline in Excel. The only real challenge is to choose the trendline type that best corresponds to the type of data you are analyzing. In this tutorial, you will find the detailed description of all the trendline options available in Excel and when to use them. Continue reading

## How to add trendline in Excel chart

When plotting data in a graph, you may often want to visualize the general trend in your data. This can be done by adding a trendline to a chart. Luckily, Microsoft Excel has made inserting a trend line very easy, especially in newer versions. Continue reading

## How to find, highlight and label a data point in Excel scatter plot

In situations when there are many points in a scatter graph, it could be a real challenge to spot a particular one. Professional data analysts often use third-party add-ins for this, but there is a quick and easy technique to identify the position of any data point by means of Excel. Continue reading

## How to create a scatter plot in Excel

When looking at two columns of quantitative data in your Excel spreadsheet, what do you see? Just two sets of numbers. Do you want to see how the two sets are related to each other? The scatter plot is the ideal graph choice for this. Continue reading

## How to add a line in Excel graph (average line, benchmark, baseline, etc.)

In situations when you want to compare the actual values with the target you wish to achieve, you can draw a horizontal line in your Excel graph such as an average line, baseline or target line. This can be done by combining two different chart types in the same graph. Continue reading

## How to create a line graph in Excel

The line graph is one of the simplest and easiest-to-make charts in Excel. Line charts are commonly used in statistics and science because they show trends clearly and are easy to plot. Continue reading

## Linear regression analysis in Excel

Run regression analysis in Excel to get the answers to the following questions: Which factors matter and which can be ignored? How closely are these factors related to each other? And how certain can you be about the predictions? Continue reading

## How to create Pareto chart in Excel

Do you want to know the principle causes to which you should devote the most efforts? It is what the Pareto principle, or the law of the vital few, is all about. Continue reading

## Excel Cumulative Sum - easy way to calculate running total

This short tutorial shows how a usual Excel Sum formula with a clever use of absolute and relative cell references can quickly calculate a running total in your worksheet. Continue reading

## How to create a histogram chart in Excel 2019, 2016, 2013 and 2010

While everyone knows how easy it is to create a chart in Excel, making a histogram usually raises a bunch of questions. In fact, in the recent versions of Excel 2010, Excel 2013, and Excel 2016, creating a histogram is a matter of minutes and can be done in a variety of ways. Continue reading

## Automatically create 3D bubble charts in Excel with the 5dchart Add-in

From this article you'll learn about the 5dchart add-in. It's a flexible and easy-to-use Excel tool that makes creating 3D bubble charts and scatter plots fun and easy. Continue reading

## How to create a bar graph in Excel

In this tutorial, you will learn how to make a bar graph in Excel, how to have values sorted automatically descending or ascending, how to create a bar chart in Excel with negative values, how to change the bar width and colors, and much more. Continue reading

## How to create a Pie chart in Excel

In this Excel pie chart tutorial, you will learn how to make a pie chart in Excel, add or remove the legend, label your pie graph, show percentages, explode or rotate a pie chart, and much more. Continue reading

## Make a chart in Excel from two or more different sheets

The tutorial demonstrates how to make charts in Excel from multiple sheets, and how to customize and edit such graphs. Continue reading

## Customizing Excel charts: add chart title, axes, legend, data labels and more

The tutorial shows how to create and customize graphs in Excel: add a chart title, change the way that axes are displayed, format the chart legend, add data labels, and more. Continue reading

## How to create a chart (graph) in Excel and save it as template

The tutorial explains the Excel charts basics and provides the detailed guidance on how tou will also learn how to combine two chart types, save a graph as chart template, change the default chart type, resize and move the graph. Continue reading

## How to create waterfall chart in Excel (bridge chart)

This article looks at creating basic graphs and at a special chart type – the Waterfall chart in Excel. Read on to find out what a waterfall chart is and when you can find it useful. You'll learn what tools can help you with creating waterfall charts in Excel 2016, 2013. Continue reading