Excel Charts

Turning Numbers into a Chart

A table of numbers is precise, but a chart is fast to read - it lets someone spot a trend or an outlier in a second instead of scanning a grid of cells. In Excel, you build a chart by first selecting a range of data (including its header row) and then choosing a chart type from the Insert tab. The chart Excel creates stays linked to that range, so it updates automatically whenever the underlying numbers change.

Choosing the Right Chart Type

• Column or Bar - best for comparing a value across a handful of categories
• Line - best for showing a trend over time, such as monthly revenue
• Pie - best for showing how a whole splits into a few parts (keep it to 5-6 slices or fewer)
• Scatter - best for showing the relationship between two numeric variables

Inserting a Chart in Three Clicks

1. Select A1:B7 (Month and Revenue, including headers)
2. Insert tab > Charts group
3. Click Insert Column or Bar Chart > Clustered Column
4. The chart appears on the sheet - drag its border to reposition it

Adding Titles, Labels, and a Legend

Click the chart to select it, then click the plus-sign 'Chart Elements' button that appears at its top-right corner (or use the Chart Design tab). From there you can turn on a Chart Title, Axis Titles, Data Labels showing the exact value above each bar, and a Legend to identify each series when a chart plots more than one. Double-clicking any title lets you retype it directly on the chart.

Adjusting a Chart After You've Made It

Nothing about a chart is permanent. 'Switch Row/Column' on the Chart Design tab flips which axis reads the categories and which reads the series - useful when Excel guesses the layout backwards. 'Select Data' lets you add, remove, or re-point a series to a different range. And 'Change Chart Type' swaps the whole chart - a column chart into a line chart, for instance - without losing the formatting you've already applied.