In this guide, I'll walk you through the different ways to format your chart, with Excel's main chart-formatting actions written in bold so you can find them more easily.

How Excel Charts Work A chart has an x-axis range and a y-axis range to show the correlation between two different data sets. The x-axis is the horizontal category line.

You can insert a chart in Excel by selecting your dataset, heading over to the Insert tab, and clicking the chart type you want in the Charts group of the ribbon. Then, you can customize them by ...

How to Change a Range in Microsoft Excel. When you copy a formula, referenced ranges automatically adjust according to the formula's new position unless the ranges use absolute references.

Want to name a range in Microsoft Excel? This post shows how to edit or create Named Ranges in Excel using four methods.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.

If the chart doesn’t update, check the range references. For a dynamic chart technique that takes a different route, read Create a dynamic Excel chart and make your own dashboard.

Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use ...