Chart & Visualization Issues

How to Change the Font Size of All PowerPoint Chart Labels

Adam Davis Oct 9, 2026 868 views

Question details

The user needs a method to select and change the font size of data labels across multiple chart series simultaneously.

How to Change the Font Size of All PowerPoint Chart Labels

Product: PowerPoint
Device & OS: not provided
Scenario: Formatting a presentation chart containing multiple data series to improve the readability of data labels.
Observed behavior: PowerPoint does not offer a direct command to select only data labels from every series at once; changing the whole chart font affects axes and legends as well.

Before you start

Before proceeding, ensure your presentation is saved. If you plan to use the VBA macro method for precise targeting, you must have the Developer tab enabled in your PowerPoint ribbon.

Solution 1Recommended

Use a VBA Macro to Resize All Data Labels Precisely

Since PowerPoint lacks a built-in button to select all labels across series, using a VBA macro is the most precise method to change only the data labels without affecting the axes or legend.

A VBA script allows you to programmatically loop through every data series and every individual data label in the active chart, specifically targeting and updating their font size in a single action.

Select the target chart

Click anywhere on the chart in your PowerPoint slide so that it is recognized as the active chart.

Open the VBA Editor

Press 'Alt + F11' on your keyboard to open the Visual Basic for Applications (VBA) editor.

Insert a new Module

In the VBA editor, click 'Insert' from the top menu, then select 'Module' to open a blank coding window.

Run the formatting code

Paste a VBA script that loops through 'ActiveChart.FullSeriesCollection' and sets '.DataLabels.Format.TextFrame2.TextRange.Font.Size' to your desired numerical value. Press 'F5' to run the macro.

Use a VBA Macro to Resize All Data Labels Precisely

Macro File Format: If you want to reuse this macro in the future, remember to save your PowerPoint file as a Macro-Enabled Presentation (.pptm).

Solution 2

Change the Font Size for the Entire Chart Area

If you need a quick fix and do not mind if the axes and legend are resized alongside your data labels, you can apply font formatting to the entire chart area.

Free Microsoft Office alternative

Try WPS Office for Seamless Presentation Editing

While highly specific chart modifications in Microsoft PowerPoint often require complex VBA scripting, WPS Presentation provides an intuitive, lightweight, and completely free alternative for creating and editing your slideshows.

1. Download and Install: Download WPS Office for free from the official website and install it on your device.
2. Open your Presentation: Open your existing .pptx files directly within WPS Presentation with no formatting loss.
3. Edit Chart Elements: Double-click on any chart element to bring up intuitive side-panel formatting options for quick text and label adjustments.

Fully compatible with Microsoft PowerPoint formats (.ppt, .pptx).User-friendly chart visualization and formatting tools.Lightweight application that runs smoothly even on older devices.Completely free to use with a highly familiar ribbon interface.

microsoft office alternative - wps office

Frequently Asked Questions

Can I select multiple data series labels by holding the Ctrl key?

No, PowerPoint does not currently support selecting data labels from multiple different series simultaneously using the Ctrl or Shift key. You must modify them one series at a time or use VBA.

Why did my axis and legend font change when I resized the labels?

If you selected the entire 'Chart Area' rather than an individual data label series, any font size adjustment made in the Home tab will uniformly apply to all text elements in the chart.

How can I change the font size of just one specific data series?

Click once on any data label within the target series. This selects all labels for that specific series. Then, go to the Home tab and adjust the font size from the dropdown menu.

Do VBA macros work in PowerPoint for Mac?

Yes, VBA is supported in modern desktop versions of PowerPoint for Mac. However, the Visual Basic Editor interface may look slightly different than it does on Windows.

Excel & Data Problems