Formatting Issues

How to Change Data Label Font Size Across Multiple PowerPoint Charts

Emma BrownEmma Brown Nov 4, 2026 872 views

Question details

The user needs to increase the font size of data labels across numerous embedded charts in a PowerPoint presentation without having to edit each individual chart manually.

How to Change Data Label Font Size Across Multiple PowerPoint Charts
Product
PowerPoint
Device & OS
not provided
Scenario
Updating the aesthetic design of a presentation where multiple embedded charts require consistent, larger data label text sizes.
Observed behavior
PowerPoint lacks a global Slide Master setting specifically for chart data labels, making mass formatting difficult without the use of saved templates or macros.
Before you start

Ensure you save a backup copy of your presentation file before running any VBA macros or overwriting your existing chart styles to prevent accidental data loss.

Solution 1Recommended

Use a VBA Macro to Automate Font Size Changes

Running a VBA macro is the most efficient method to instantly apply a uniform font size to data labels across all charts in your presentation.

This macro iterates through every slide and shape in your active presentation. When it identifies a chart with enabled data labels, it automatically adjusts the text to 24 points (or any size you define in the code).

1
Open the VBA Editor

Press Alt + F11 on your keyboard to launch the Microsoft Visual Basic for Applications window.

2
Insert a New Module

Click 'Insert' from the top menu ribbon and select 'Module' to create a blank script window.

3
Paste the Macro Code

Copy and paste the required VBA script (Sub inc_DL) into the module window. Ensure the code contains the line 'ocht.SeriesCollection(L).DataLabels.Font.Size = 24' to set the desired font size.

4
Run the Macro

Press F5 or click the 'Run' button in the toolbar to execute the code. All applicable charts in the presentation will update instantly.

Use a VBA Macro to Automate Font Size Changes
Macro Execution Complete: Your data label font sizes have been successfully updated globally without the need for manual clicking.
WPS Presentation

Easily Manage Chart Formatting with WPS Presentation

WPS Presentation empowers you to efficiently format chart elements and save customized styles as templates. Easily apply consistent data label font sizes across your slides with this highly compatible and user-friendly Office suite.

  1. 1. Open Your Presentation: Launch WPS Presentation and open your .pptx file containing the charts you want to format.
  2. 2. Format Data Labels: Click on your chart data labels and use the convenient right-side formatting pane to adjust the font size to your exact preference.
  3. 3. Save and Reuse: Right-click the formatted chart to save it as a custom template, then easily apply it to the rest of your charts to maintain brand consistency.
Fully compatible with Microsoft PowerPoint (.ppt and .pptx) formatsQuickly save and apply custom chart templatesLightweight application with an intuitive, familiar user interfaceFree and highly efficient alternative to Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Can I adjust chart data label sizes using the PowerPoint Slide Master?

No, PowerPoint's Slide Master controls general slide layouts, text placeholders, and background designs. It does not support granular, global formatting settings for embedded chart elements like data labels.

Will the VBA macro affect PowerPoint charts that do not currently have data labels?

No, the recommended macro code includes a conditional check to ensure that it only attempts to modify the font size of charts that already have data labels enabled.

Do I need a separate chart template for different chart types?

Yes, chart templates are uniquely tied to the type of chart (e.g., column chart vs. pie chart). You will need to save a separate template for each chart type present in your presentation.

Can I manually select all text in a chart at once to change the font size?

While you cannot select all independent chart elements globally, you can select an individual chart, press Ctrl+A to highlight all text within that specific chart, and adjust the font size from the home ribbon.