Add a feature

Better Access Charts provides a variety of ways to create charts with Chart.js. But not all the parameters provided by chart.js for customizing charts have been implemented. This article describes step by step how a parameter available in chart.js can be integrated into Better Access Charts.

1. Save HTML file

Create a chart with all desired parameters. Finally, on the "Chart" tab, select "Save html file for debugging" and create the chart again.

2. Open HTML file

The HTML file is saved in the folder where the Better Access Charts database is saved. The file is named "BetterAccessChart_XXXXXXXXX.html". Open this file in a text editor such as Notepad++.

3. Adjust HTML file

Search the chart.js documentation for the parameter you want to adjust. Add the necessary information to the HTML file and save the result.

4. Open the HTML file in the browser

Open the HTML file you customized in the browser. Your customization should now be visible here as desired. If not, go back to step 3.

5. Adjust VBA code

Adjust the VBA code at the appropriate place. Enter the necessary information there so that the HTML file you have customized is generated at the end.

6. A final note

If you think your customization is useful for other users, please open an issue, describe the customization and attach a customized database. I'm always interested in new ideas.

There is an article on my blog that describes this procedure in a little more detail: https://blog.team-moeller.de/2023/09/better-access-charts-eigene.html. The text is in German but with today's translation tools that's certainly not a problem ;-)