Others

How to Change Gap Width and Data Label Size in Access Charts

Huma Ashraf ChHuma Ashraf Ch Nov 3, 2026 870 views

Question details

The user wants to adjust the spacing (gap width) between bars and resize data labels in a Microsoft Access chart but is unable to find the settings.

How to Change Gap Width and Data Label Size in Access Charts
Product
Microsoft Access
Device & OS
not provided
Scenario
Creating a visual chart representation of database records and attempting to customize the visual layout for better readability.
Observed behavior
Modern Access charts provide highly limited control over chart formatting, omitting native settings to adjust gap widths and specific data label sizes.
Before you start

Ensure your database query or table containing the target chart data is saved, as advanced visual customization requires exporting this data to a dedicated spreadsheet application.

Solution 1Recommended

Export Access Data to a Spreadsheet for Chart Formatting

Since Access lacks advanced chart formatting features, exporting your dataset to a spreadsheet program allows full control over chart elements like gap widths and label sizes.

Microsoft Access is optimized for database management rather than advanced graphical reporting. Modern charts in Access have strict limitations on element customization.

By exporting the underlying data to a spreadsheet tool like Excel or WPS Spreadsheet, you can utilize dedicated chart formatting menus to perfect your visual presentation.

1
Export the Data

Open Microsoft Access, locate the table or query containing your data, right-click it, and select 'Export' followed by 'Excel' or 'Text File (CSV)'.

2
Open in a Spreadsheet

Launch your spreadsheet application (such as Excel or WPS Spreadsheet) and open the newly exported file.

3
Insert a New Chart

Select the relevant data range, navigate to the 'Insert' tab on the top ribbon, and choose your preferred chart type.

4
Adjust Gap Width

Right-click on one of the data bars in your new chart and select 'Format Data Series'. In the formatting pane that appears, locate the 'Gap Width' slider and adjust it to your desired spacing.

5
Change Data Label Size

Click directly on the data labels within the chart to select them, then use the standard font size dropdown in the 'Home' tab to increase or decrease their size.

Export Access Data to a Spreadsheet for Chart Formatting
Using Templates: If you generate these reports frequently, consider creating a spreadsheet template with a pre-formatted chart on a separate sheet. You can then simply paste new Access data into the data sheet to update the chart instantly.
Free Microsoft Office alternative

Create Highly Customizable Charts with WPS Office

When Microsoft Access limits your ability to format charts natively, exporting your data to WPS Spreadsheet provides a seamless solution. WPS Office is a free, lightweight suite offering robust chart formatting capabilities, allowing you to easily adjust gap widths, label sizes, and colors without the heavy resource usage of Microsoft Office.

  1. 1. Import Exported Data: Open WPS Spreadsheet and load the CSV or Excel file exported from Microsoft Access.
  2. 2. Generate the Chart: Highlight your dataset, click the 'Insert' tab, and select a Column or Bar Chart.
  3. 3. Format Gap Width and Labels: Double-click the chart bars to open the settings pane and modify the Gap Width percentage. Select data labels and use the Home tab to adjust font properties.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv) for seamless data importing from Access.Advanced, easy-to-use chart formatting pane to adjust gap widths, series overlap, and typography.Free and lightweight alternative to Microsoft Office that runs smoothly on all devices.Familiar user interface requires no learning curve to create professional data visualizations.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Access restrict chart formatting like gap widths?

Modern charts in Microsoft Access were designed to provide quick, basic visualizations directly within forms and reports. To keep the interface streamlined, advanced formatting tools found in dedicated spreadsheet software were omitted.

Can I link my spreadsheet chart to Access so it updates automatically?

Yes. Instead of exporting data manually each time, you can open your spreadsheet application and use the 'Get Data' or 'Import Data' feature to connect directly to your Access database. The spreadsheet chart will then refresh automatically when the database updates.

What is the ideal gap width for a bar chart?

While it depends on personal preference and the number of data points, a common best practice is to set the gap width between 50% and 150% of the bar width. This ensures the bars are distinct but still visually grouped as a cohesive data set.