Data is rarely so uniform and predictable that plotting data points creates a perfectly linear arrangement. Scatter charts might have wildly varying plots that create a seemingly random correlation ...

Excel offers a wide variety of charts and graphs, each designed to help you uniquely visualize data. But choosing the right chart isnt always straightforward. Let's break down the essential Excel ...

Column graphs offer a visual representation of data that allows easy comparison between multiple values. Typically, these columns are uniformly spaced, but there are times you will need to group ...

So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab, getting ...

Bar graphs are graphical representations of statistical data in the form of strips or bars. This allows viewers to understand the difference between the various parameters of the data at a glance ...

An curved arrow pointing right. Sparklines are word-sized charts that live in individual cells. This great feature was added to Excel in 2010 but still remains massively underutilized. Produced by ...

This article will be handy if you want to rename or edit the data series name in a Microsoft Excel graph or chart without changing the row or column name. The data series is the data that appears at ...

Two weeks ago I announced a bad graph contest to try to encourage software vendors to improve their offerings. Readers nominated a number of bad graphs for the contest. This post discusses some of the ...

An curved arrow pointing right. Sparklines are word-sized charts that live in individual cells. This great feature was added to Excel in 2010 but still remains massively underutilized. Produced by ...