Exporting Data from Access to Excel Part 11: VBA Formatting Graph Axes

VBA for Formatting Graph Axes

**The VBA code used in this video can be found here:

Some customers are comfortable manually exporting data from Access to spreadsheets. However, many will want that 'magic button' that does it for them. When you need a button, it's time to transfer data via VBA.

In this video, we will use Access to control Excel. We will produce an Excel spreadsheet that contains a graph using VBA in an Access database. We will explore some of the options available for formatting graph axes.

All of my videos organized by topic and other blog topics:

Videos in this series:
Introduction to exporting data from Microsoft Access to Excel: Part 1

Introduction to exporting data from Microsoft Access to Excel: Part 2

Introduction to exporting data from Microsoft Access to Excel: Part 3

Exporting Data from Access to Excel Part 4: Formatting

Exporting Data from Access to Excel Part 5: Formulas

Exporting Data from Access to Excel Part 6: Lines

Export from Access to Excel Part 7: Colors/Conditional Formatting

Exporting Data from Access to Excel Part 8: VBA for Page Setup

Exporting Data from Access to Excel Part 9: Easy Graphing

Exporting Data from Access to Excel Part 10: Graphing from VBA

Exporting Data from Access to Excel Part 11: VBA Formatting Graph Axes

Exporting Data from Access to Excel Part 12: Formatting Graph Legends

Exporting Data from Access to Excel Part 13: Formatting Graph Colors

Exporting Data from Access to Excel Part 14: Formatting Graph Data Series