Implementation of Chart Automatically Drawing in Excel Based on VBA

Author:

Dong Guo Liang1,Xu Shu Quan1,Liu Fu Jia1

Affiliation:

1. Highway Ministry of Transport

Abstract

Drawing charts are odd work by adding a data source manually and setting other parameters such as border, legend etc in Excel. The key technologies and implementation methods of chart-automatic-drawing are described using embedded VBA Programming codes.

Publisher

Trans Tech Publications, Ltd.

Reference6 articles.

1. Yao Wen-tao: Excel VBA Application Programming Instances[M] , Tsinghua University Press (2009).

2. Yunzhou Stiduo: Excel 2000 VBA[M], Posts & Telecom Press (2000).

3. Microsoft Corporation: Microsoft Excel Help[DB/OL].

4. Microsoft Corporation: Microsoft Excel 2000 Language Reference [M], Beijing Hope Electronic Press (1999).

5. Douglas Hergert: Foundation of Visual Basic 4 For windows 95 Programming [M], IDG Book Worldwide inc. (1995).

Cited by 1 articles. 订阅此论文施引文献 订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献

1. Research on AutoCAD secondary development and function expansion based on VBA technology;IOP Conference Series: Earth and Environmental Science;2017-06

同舟云学术

1.学者识别学者识别

2.学术分析学术分析

3.人才评估人才评估

"同舟云学术"是以全球学者为主线,采集、加工和组织学术论文而形成的新型学术文献查询和分析系统,可以对全球学者进行文献检索和人才价值评估。用户可以通过关注某些学科领域的顶尖人物而持续追踪该领域的学科进展和研究前沿。经过近期的数据扩容,当前同舟云学术共收录了国内外主流学术期刊6万余种,收集的期刊论文及会议论文总量共计约1.5亿篇,并以每天添加12000余篇中外论文的速度递增。我们也可以为用户提供个性化、定制化的学者数据。欢迎来电咨询!咨询电话:010-8811{复制后删除}0370

www.globalauthorid.com

TOP

Copyright © 2019-2024 北京同舟云网络信息技术有限公司
京公网安备11010802033243号  京ICP备18003416号-3