How to Change Gap Width and Data Label Size in Access Charts
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.

- 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.
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.
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.
Open Microsoft Access, locate the table or query containing your data, right-click it, and select 'Export' followed by 'Excel' or 'Text File (CSV)'.
Launch your spreadsheet application (such as Excel or WPS Spreadsheet) and open the newly exported file.
Select the relevant data range, navigate to the 'Insert' tab on the top ribbon, and choose your preferred chart type.
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.
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.

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. Import Exported Data: Open WPS Spreadsheet and load the CSV or Excel file exported from Microsoft Access.
- 2. Generate the Chart: Highlight your dataset, click the 'Insert' tab, and select a Column or Bar Chart.
- 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.

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.




