How to Edit Graphs in Excel | Chart Editing Tips

Editing charts in Excel gives you full control over data ranges, chart types, colors, and axis formatting through two contextual ribbon tabs.

Making a chart look right the first time is rare — the real skill is knowing how to fix it afterward. The first thing to understand about how to edit graphs in Excel is that the editing tools only appear when the chart is selected. Click the chart once, and two hidden tabs — Chart Design and Format — show up on the ribbon. From there you can swap data ranges, change the visualization type, adjust colors and fonts, and fine-tune every axis bound and trendline. The tools are the same across Excel for Microsoft 365, Excel 2021, and Excel 2016 on both Windows and Mac.

The Core Workflow: Select, Then Edit

The Chart Design and Format tabs are contextual — they exist in the ribbon but only appear when a chart is selected. Click the chart once (or use the arrow keys to navigate to it), and both tabs pop into view at the top of the window. No selection means no editing tools.

This is the single most common mistake people make. They look for chart options under Insert or Home and don’t find them. Select the chart first, and the full editing toolbox is one click away.

Edit an Excel Graph: The Step Order That Works

To change what data your chart pulls from, right-click the chart and select Select Data. The Select Data Source dialog opens, showing every current series under Legend Entries (Series). Click Edit to adjust the range, or use Move Up and Move Down to reorder series. Click OK when you’re done. Microsoft’s official walkthrough for changing chart data series covers the full dialog.

If your data is plotted wrong — categories on the wrong axis — click Switch Row/Column in the same dialog to flip the orientation. The chart redraws immediately, and the series now match your intended layout.

One gate worth knowing: if the source data lives in a closed workbook, the Select Data dialog warns that some options are unavailable. Open the source file first, then edit.

Switch Chart Types Without Redrawing

You don’t have to delete and rebuild a chart to change its look. Select the chart, go to the Chart Design tab, and click Change Chart Type. Pick a new type — bar, line, pie, scatter, or area — and Excel converts the existing chart with all your data intact. Right-clicking the chart and selecting Change Chart Type from the context menu works just as fast.

The switch keeps your current data labels, colors, and sizing where the new type supports them. A few specialized formats (waterfall, funnel, treemap) may drop features like trendlines during conversion — check the result after the switch.

How Do You Fix a Chart With the Wrong Data?

When the numbers on your chart don’t match what you expect, start with the Chart Filters button — the green icon next to the chart. Click it to see every series and category. Uncheck the ones you want to hide and click Apply. No redrawing needed, and the hidden data still exists in the spreadsheet.

If individual data points still look off, check whether the chart’s source range drifted. Go to Chart Design > Select Data and confirm the range in the Chart Data Range field. When the source range is correct but a point still reads wrong, look for hidden rows or filtered-out cells in the spreadsheet — charts skip hidden data by default. Unhide the rows or use Select Data to point at an unfiltered range.

A quick after adjusting the range, each data point should match the cell it references. If a value changed in the sheet but the chart didn’t update, the range probably wasn’t saved — reopen Select Data and confirm the range, then click OK.

Add Titles, Labels, and Trendlines

Click the chart to activate Chart Design, then click Add Chart Element. The dropdown lists every element you can add to the chart. Each option has sub-types — for example, Data Labels gives you center, inside end, outside end, and data callout placements.

• Chart Title — Adds a placeholder you can type over or link to a cell.
• Data Labels — Shows values directly on bars, lines, or points.
• Trendline — Choose Linear, Exponential, Moving Average, or other options. Right-click the trendline afterward to format its line style and forecast period.
• Axis Titles — Labels for the horizontal and vertical axes.
• Legend — Controls where the legend sits or hides it entirely.

Right-click any existing element — a title, an axis, a data label — and pick Format to open the side pane with every style option for that element. This is where you change font size, color, and position without hunting through the ribbon.

Fine-Tune Axes and Colors

Right-click an axis and select Format Axis to open the Format Axis pane on the right. Here you can set explicit Minimum and Maximum bounds so the chart doesn’t auto-scale in a misleading way. Adjust the Major and Minor units to control gridline spacing and tick-mark density.

For colors and fonts, right-click any data series and pick Format Data Series. The pane switches to that element’s options — fill color, border, shadow, glow, and gap width for bars. These same controls work on individual data points if you click one point twice (single-click selects the whole series, second click selects the point). Change the point’s fill to draw attention to a specific value.

A secondary axis is useful when two data series have very different scales. To add one, select the target series in the chart, right-click, and select Format Data Series. Under Series Options, check Secondary Axis. The chart now shows two vertical axes with independent bounds.

Follow This Sequence to Edit Any Excel Chart

Here is the step order that handles 95 percent of chart editing jobs, from a quick data fix to a full visual overhaul:

1. Select the chart — unlocks the Chart Design and Format tabs.
2. Edit the data range — right-click > Select Data.
3. Pick the right chart type — Chart Design > Change Chart Type.
4. Add or format elements — Add Chart Element or right-click > Format.
5. Clean up axis bounds and colors — via the Format Axis and Format Data Series panes.
6. Apply filters — use the Chart Filters button to show or hide specific series.

This sequence works identically in Excel for Microsoft 365, Excel 2021, and Excel 2016 on both Windows and Mac. The one constant across every version: select the chart first — everything else follows from that click.