(See our Excel tables tutorial for instructions ... Sometimes you don’t need a full chart but simply want to highlight a small trend within the data. That’s where sparklines come in.

In this example, I've selected the legend on the chart, and the pane has automatically launched the Format Legend options.

There are 17 different types of charts in Excel, so it can sometimes be difficult ... best way to show simple data comparisons. In this example, the chart displays the number of airplanes (y ...

One of the advantages of using Excel as... A clustered chart is excellent for making relative comparisons within categories, but makes totals more difficult to determine. Using our example of a ...

Microsoft Excel 2007 supports a variety of chart types to create a combination chart and help your viewers see the differences between two or more data series. For example, one data series in a ...

In this tutorial, I’ll show you a few tweaks that can quickly improve the looks of Excel’s default area chart. Although we’re working with an area chart, you can apply these simple format ...

If you do not want to move a chart while changing the width of the cell, you can lock the chart position in an Excel spreadsheet ... If so, you can follow this tutorial. Let’s delve into these ...

The below example shows the line chart’s default behavior, which drops the one to zero on the X-axis. The line chart plots zero by default, which can be a bit abrupt. Excel plots four stacks for ...

So, you want to know how to create a scatter plot in Excel ... s what on the chart — it’s all just dots and lines. Thankfully, you can show data in several ways. In one example, we could ...

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.