Chart & Visualization Issues

How to Display Values Below Bars in Excel and PowerPoint Charts

Natalie Taylor Oct 1, 2026 868 views

Question details

The user wants to position data labels containing values directly below the columns or bars in an Excel or PowerPoint chart.

How to Display Values Below Bars in an Excel or PowerPoint Chart

Product: Spreadsheets and Presentations
Device & OS: not provided
Scenario: Creating or formatting a column/bar chart where data values need to be displayed directly underneath the graphical bars for reporting or visual preferences.
Observed behavior: Office software provides automatic label positions like Inside Base or Outside End, but lacks a built-in option to place labels directly below the column, requiring manual workarounds or scripts.

Before you start

Ensure your chart is fully populated with the final data before adjusting label positions, as changing the number of columns later may reset your manual adjustments.

Solution 1Recommended

Adjust Data Labels Manually Using the Inside Base Position

Set the labels to the Inside Base position to get them as close to the bottom as possible, then manually drag them below the bars.

Since there is no automatic 'Below Bar' positioning built into the standard chart options, setting the initial position to 'Inside Base' gives you the best starting point for manual adjustments.

Add Data Labels

Click on your chart, go to the Chart Elements menu (the plus icon next to the chart), and check the box for 'Data Labels'.

Open Format Data Labels

Right-click one of the newly added data labels and select 'Format Data Labels' from the context menu to open the side panel.

Change Label Position

In the Format pane, locate the Label Position section and choose 'Inside Base'. You can also enable 'Value' and 'Category Name' in the Label Contains section if needed.

Move Labels Below Bars

Click on individual data labels to select them one by one. Drag each label directly below its corresponding column. Be sure to uncheck 'Show Leader Lines' in the format pane so no line connects the moved label to the bar.

Adjust Data Labels Manually Using the Inside Base Position

Template Limitations: If you save a manually positioned chart as a template, the custom placements may not align correctly when applied to charts of different sizes.

Solution 2

Use VBA Macros for Dynamic Charts

For stacked column charts or charts where the number of columns changes frequently, manual placement will not work, and VBA is required.

Try WPS Office

Create and Format Professional Charts in WPS Spreadsheet

WPS Office provides a highly intuitive and familiar interface for creating diverse charts, customizing data labels, and adjusting visualizations with ease.

1. Open Your Data: Launch WPS Spreadsheet and open your workbook containing the chart data.
2. Insert a Chart: Highlight your data range, go to the 'Insert' tab, and select 'Chart' to choose your preferred column or bar chart style.
3. Add Data Labels: Click the 'Chart Elements' shortcut next to the chart and enable 'Data Labels'.
4. Format Labels: Double-click the labels to open the side panel, select 'Inside Base', and manually drag them below the chart bars for a customized look.

Easily add, format, and freely position chart data labels.Fully compatible with Microsoft Excel (.xlsx) and PowerPoint (.pptx) formats.Rich built-in chart templates to save time on manual formatting.Lightweight and free to use for everyday office tasks.

Frequently Asked Questions

Why do my manually moved data labels jump back when data changes?

Manually positioned labels use absolute coordinates. If the chart resizes, the data values change significantly, or new columns are added, the chart automatically redraws, which often resets custom label placements.

Can I save the 'Below Bar' label position in a chart template?

While you can save a customized chart as a template, manually positioned elements like dragged data labels often do not align properly when the template is applied to a new chart with different dimensions or data sets.

Is there a built-in 'Below Bar' data label position in Office?

No, standard chart tools currently only provide automatic position presets such as Center, Inside End, Inside Base, and Outside End. Placement directly below the column requires manual dragging or VBA scripting.

How do I remove the lines connecting the moved label to the bar?

When you drag a data label away from its default position, a leader line may automatically appear. To remove it, right-click the labels, select 'Format Data Labels', and uncheck the 'Show Leader Lines' option in the format pane.

Excel & Data Problems