ScholarLens Back to search
2019•Unpublished venueRequires access

Working with Charts

M. Alexander, Dick Kusleika

Open publisher page 0 citations

Abstract

An Excel chart is simply packed with objects, each of which has its own properties and methods. Because of this, manipulating charts with Visual Basic for Applications (VBA) can be a bit of a challenge. This chapter discusses the key concepts that one needs to understand to write VBA code that generates or manipulates charts. To create a chart directly on a chart sheet, use the Add2 method of the Charts collection. The Add2 method of the Charts collection uses several optional arguments, but these arguments specify the position of the chart sheet—not chart-related information. Enhancements introduced with Excel 2013 make it easier than ever for end users to create and modify charts. When a user clicks any area of an embedded chart, the chart is activated. VBA code can activate an embedded chart with the Activate method. The chapter uses methods other than the macro recorder to help one learn about Chart objects.

About this research paper

What this paper is about

An Excel chart is simply packed with objects, each of which has its own properties and methods. Because of this, manipulating charts with Visual Basic for Applications (VBA) can be a bit of a challenge. This chapter discusses the key concepts that one needs to understand to write VBA code that generates or manipulates charts. To create a chart directly on a chart sheet, use the Add2 method of the Charts collection. The Add2 method of the Charts collection uses several optional arguments, but these arguments specify the position of the chart sheet—not chart-related information. Enhancements introduced with Excel 2013 make it easier than ever for end users to create and modify charts. When a user clicks any area of an embedded chart, the chart is activated. VBA code can activate an embedded chart with the Activate method. The chapter uses methods other than the macro recorder to help one learn about Chart objects.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

An Excel chart is simply packed with objects, each of which has its own properties and methods. Because of this, manipulating charts with Visual Basic for Applications (VBA) can be a bit of a challenge. This chapter discusses the key concepts that one needs to understand to write VBA code that generates or manipulates charts. To create a chart directly on a chart sheet, use the Add2 method of the Charts collection. The Add2 method of the Charts collection uses several optional arguments, but these arguments specify the position of the chart sheet—not chart-related information. Enhancements introduced with Excel 2013 make it easier than ever for end users to create and modify charts. When a user clicks any area of an embedded chart, the chart is activated. VBA code can activate an embedded chart with the Activate method. The chapter uses methods other than the macro recorder to help one learn about Chart objects.

Key concepts: Visual Basic for Applications, Chart, Computer science, Macro, Pie chart, Code (set theory), Engineering drawing, Programming language

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Working with Charts — Research Paper | ScholarLens