How to Change Data Label Font Size Across Multiple PowerPoint Charts
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.

- 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.
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.
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).
Press Alt + F11 on your keyboard to launch the Microsoft Visual Basic for Applications window.
Click 'Insert' from the top menu ribbon and select 'Module' to create a blank script window.
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.
Press F5 or click the 'Run' button in the toolbar to execute the code. All applicable charts in the presentation will update instantly.

Save and Apply a Custom Chart Template
If you prefer not to use code, you can format a single chart perfectly and save its style as a template to quickly apply to other charts.
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. Open Your Presentation: Launch WPS Presentation and open your .pptx file containing the charts you want to format.
- 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. 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.

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.




