To bring one series to the front of an Excel area chart, select the chart, choose Chart Design > Select Data, select the series under Legend Entries (Series), and click Move Down until it is last in the list. Excel draws later series over earlier ones, so the last series is generally the foreground area.
First, distinguish a series from the chart object
People use bring to front to mean two different things in Excel. A chart contains data series, such as revenue and expenses, and each series can have a filled area. Separately, the chart itself is an object on the worksheet, like a picture or a shape. Changing the series order changes which colored area covers another inside the plot. Changing the chart object’s position changes whether the entire chart sits over or behind other worksheet objects.
If one color is hiding another inside the chart, change the series order. If a text box, picture, or shape is covering the whole chart, change the order of the chart object instead. These actions are independent: bringing the chart object forward will not change which data series is in front within the chart.
Reorder an area-chart series in Excel for Windows
In Excel for Microsoft 365 on Windows, the Select Data Source dialog is the most direct way to control the series order. Use these steps:
- Click the area chart. If you have trouble selecting it, click an empty part of its border rather than a colored area.
- Open Chart Design > Select Data.
- Under Legend Entries (Series), click the series you want to show in front.
- Click Move Down until the series is at the bottom of the list. Each click moves it one position.
- Click OK and check the chart. The selected series should now be drawn over the series that precede it.
The dialog may label the series by its header cell, so a series called North or 2025 is easier to identify than one named Series 3. If the order is not immediately clear, compare the dialog entries with the chart legend. Reordering does not change the worksheet values or the series’ category and value ranges; it changes the order Excel uses to plot the series.
How series order controls the visible area
A standard area chart fills the space between each series’ values and the horizontal axis. Where two filled areas overlap, the later-drawn area can cover part or all of an earlier one. Moving a series down in the Select Data Source list makes it later in the plotting order and usually brings its fill to the front. Moving it up sends it earlier, where a later series may cover it.
This is a visual layering rule, not a change to the data. For example, suppose a chart contains a large blue series for total sales and a small orange series for returns. If the blue area is drawn last, it may conceal the orange values where the shapes overlap. Moving the orange series to the bottom of the list lets its area display on top. The chart still represents the same values, but the colors and visible boundaries become easier to read.
The order can also affect the legend, so check both the plot and the legend after rearranging. A series moved to the end may appear in a different position in the legend, depending on the chart layout. If the new legend order is less intuitive, consider changing the legend position or using clearer series names rather than changing the source data solely to force a preferred legend sequence.
What changes in stacked and 100% stacked area charts
In a regular area chart, series overlap against the same baseline. In a stacked area chart, Excel adds each series on top of the preceding one, so each colored band represents that series’ contribution above the accumulated values below it. Reordering those series changes the vertical stacking arrangement as well as which band is nearest the top. It is not simply a matter of placing a transparent object over another.
A 100% stacked area chart also stacks the series, but normalizes each category to a whole. It shows how the component shares change over time, not their original totals. Moving a series changes where its share appears in the stack, but not the underlying percentage calculation. If your goal is to compare individual values or see which one is largest, a stacked chart may make that comparison difficult because most bands do not share a common baseline.
Before changing order in a stacked chart, decide whether you want to emphasize a particular component, keep related components adjacent, or make the stack easier to interpret. The first series sits nearest the baseline and later series are stacked above it. Because each series’ position has meaning for the visual reading, avoid reordering merely to place a color in front without checking that the resulting stack still communicates the intended story.
Make a partly hidden series easier to see
Putting a series last may not be enough if its fill is opaque and its area covers most of the chart. You can make the foreground fill partly transparent so that the shapes beneath it remain visible. Click the series, open the Format Data Series pane, choose Fill & Line, expand Fill, and adjust Transparency. The exact pane layout can vary slightly with Excel updates, but the Fill and Transparency controls are in the series formatting options.
Transparency is useful when the goal is to show overlapping magnitudes, but too much can make colors look washed out or make the chart hard to interpret. Try a modest setting, then check the chart at the size it will actually be viewed or printed. A solid fill with a contrasting border can be clearer when readers need to distinguish the foreground series quickly. You can also reduce the number of plotted series or use a line for a small, important measure rather than filling every series.
To format a series that is difficult to click because another area covers it, select the chart and use the Current Selection list on the chart’s Format tab to choose the series by name. Then open Format Selection if needed. This lets you select a hidden series without repeatedly clicking the same visible foreground area.
Change the order of the whole chart object
If a worksheet shape is covering the chart, click the chart’s outer border to select the chart object rather than a data series. Use the contextual Format tab’s Arrange commands and choose Bring Forward > Bring to Front, if those commands are shown for the selected object. You can also right-click the object and use its ordering commands. The wording and ribbon grouping can vary with the selected object and Excel build.
Bring to Front places the chart above other overlapping objects on the worksheet; it does not move the chart above cell contents in the way a window would. To put the chart behind another object again, select it and use Send Backward or Send to Back. If the chart is difficult to select because another object is on top, use the Selection Pane from the Home tab’s Find & Select menu to select the chart by its object name, then change its order.
Why the change may seem not to work
- The wrong thing is selected. If the chart border is selected, changing series order is not available. Open Select Data and choose a series there; if a series is selected, its formatting controls appear instead.
- The desired series is not last. Move Down only shifts an entry one place. If several series are above it, click Move Down repeatedly until it reaches the bottom.
- The chart is stacked. A reordered series may move to another band rather than simply cover a neighbor. Check the chart type before interpreting the result.
- The fill still hides data. A foreground area can cover nearly all of a smaller series. Use transparency, a contrasting outline, or a different chart type to expose the information.
- The chart is based on a PivotTable. PivotCharts can have field-based controls and may restrict some changes that are available in ordinary charts. Check the PivotChart fields and source layout if the series order cannot be changed as expected.
- The wrong chart object is being changed. If the entire chart is behind a shape, change the object order; moving a data series will not solve that problem.
After editing, verify the category labels, legend, and values. In particular, confirm that no series was accidentally removed from the chart while using Select Data. If the chart is shared with others, a clear title or note can explain why a particular series is deliberately placed in the foreground.
When another chart type is a better choice
An area chart is useful for emphasizing magnitude and, in a stacked version, composition over a continuous sequence such as months or years. It is less suitable when several series overlap heavily or when readers must compare exact values across every series. Changing the foreground order can improve visibility, but it cannot recover information that an opaque area fully conceals.
Consider a line chart when the main task is comparing trends and the filled regions are distracting. Lines can cross without hiding the area under another series, and markers can help identify individual observations. A combo chart can also work when one series is especially important: show the supporting measures as areas and the key measure as a line. In Excel, select the chart and use Chart Design > Change Chart Type to explore available chart types; the exact combo options depend on the data and chart configuration.
For example, a monthly chart with total demand and a smaller target measure may be clearer as an area for demand plus a line for the target. If the purpose is to show how categories contribute to a whole, a stacked area chart may be appropriate instead. Choose based on the question the chart should answer, not just on which series can be made most prominent.
Excel for Mac and Excel for the web
In current Excel for Mac, select the chart and look for Chart Design > Select Data, then use the series list and its move controls as on Windows. Ribbon placement can differ by window width and update, but the principle is the same: place the series later in the plot order to put it in front. To change the chart object’s order, select the chart itself and use the available Arrange or Bring Forward commands on the Format ribbon.
Excel for the web has a more limited set of chart-editing controls than the desktop applications, and the exact options can vary as features are updated. If its chart interface does not offer a series-order control, reorder the series in the source table and check that the chart updates as intended, or open the workbook in desktop Excel. Keep a copy before changing source layout, especially if other formulas, charts, or reports depend on that table.
Frequently Asked Questions
Which series is in front in an Excel area chart?
The series plotted later is generally in front. In the Select Data Source list, move the series down to the bottom to make it the last one plotted.
Does Move Up bring an area series to the front?
Usually not. Move Up makes the series earlier in the order; use Move Down to move it later and toward the foreground.
Can I bring an area chart in front of a picture?
Yes. Select the chart object, not an area within it, and use Bring Forward or Bring to Front from the object-ordering commands. That affects worksheet objects, not the chart’s internal series.
Why does moving a series change the shape of my stacked area chart?
Stacked charts add each series above the ones before it. Reordering therefore changes the order of the bands and their positions in the stack, even though the source values stay the same.
Can I show two overlapping areas at once?
Try a partly transparent fill or a contrasting outline. If the chart is still difficult to read, consider a line or combo chart so the important series does not disappear beneath a filled area.
Related
- Comparison Spreadsheet Template Excel: Setup and Examples
- Comparison Table Excel Template: Build, Format, and Use
- Comparison Excel Sheet Template: Build a Clear Side-by-Side
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Add Power Pivot to the Ribbon: Steps and FixesTo add Power Pivot to the ribbon in Excel for Microsoft 365 on Windows, select File > Options…
- Excel Pivot Table: Hide Filter Buttons, Keep FiltersTo hide the filter buttons in an Excel PivotTable without clearing its current filter selections, click anywhere in…
- Excel Waterfall Chart: How to Set the Last Bar as a TotalTo make the last bar in an Excel waterfall chart show the final total, right-click that bar and…
- Excel Pivot Table Add to Data Model: A Practical GuideTo add data to the Excel Data Model, select a cell in your source range, choose Insert >…
- Excel Pivot Table: How to Sort Items in the Filter ListIn Excel for Microsoft 365 on Windows, open the PivotTable field’s drop-down and choose Sort A to Z…
- Basic Pivot Table: Create and Use One in ExcelA basic pivot table is an interactive summary of source data: in Excel for Microsoft 365 on Windows,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.