Accessing Existing Charts

When creating a chart in Excel, you have the choice of embedding the chart in an existing worksheet or creating a new worksheet to hold the chart. When a chart is created and placed in a new worksheet, it is referred to as a chart sheet. Chart sheets are special because their only function is to display a chart; they cannot be used for holding any other data. Worksheets and chart sheets serve as containers for embedded charts. There are no limits (other than system memory) to the number of embedded charts a worksheet or chart sheet can hold. Using VBA to programmatically control chart sheets and embedded charts involves the use of different objects that, at first, can be a little confusing; however, when the object model is followed, the differences make sense.

Biorhythm Awareness

Biorhythm Awareness

Who else wants to take advantage of biorhythm awareness to avoid premature death, escape life threatening diseases, eliminate most of your life altering mistakes and banish catastrophic events from your life.

Get My Free Ebook


Post a comment