Design and Implementation of Excel VBA-based Combination Charts in Analyzing Mineral Resources Data

摘要

In Mineral resource economics, a large amount of data stored in Excel files usually need to be shown in various charts for analyzing. Excel VBA provides a fast and easy way to create charts. This paper illustrates how to create batched combination charts of several mineral resources and their annual increments based on Excel VBA. Every step of creating process is illustrated in details and the Excel VBA codes are analyzed carefully. And the resulting combination charts are displayed to emphasize the different chart types and to prove the effectiveness of Excel VBA.