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

Rui Qing Du; Jing Qin Mu; Xiao Hui Li; Xue Long Zhang

doi:10.4028/www.scientific.net/AMM.687-691.1518

Paper Titles

Missing Data Clustering Based on Incomplete Information System
p.1500

Construction of Emergency Special Database Based on Quality Control Theory
p.1504

Traffic State Index Prediction Model Based on Hybrid Intelligent Methods
p.1508

Energy Field Filling of NEIC Broadband Radiated Energy Catalogue Based on Support Vector Machine Regression Model
p.1514

Design and Implementation of Excel VBA-Based Combination Charts in Analyzing Mineral Resources Data
p.1518

Numerical Solution to Volterra-Type Integro-Differential Equations of the Second Kinds by Legendre Collocation Method
p.1522

Vessel Traffic System Project Post Evaluation Method Based on Cloud Model
p.1528

The Application of Structural Equation Modeling in the Applied Linguistics Research
p.1532

Study on Chinese Word Segmentation Algorithm
p.1536

HomeApplied Mechanics and MaterialsApplied Mechanics and Materials Vols. 687-691Design and Implementation of Excel VBA-Based...

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

Abstract:

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.