If you go back far enough, you find that all charts used to be created as their own ChartSheets. Then, in the mid-1990s, Excel added the amazing capability to embed a chart right onto an existing worksheet. This allowed a report to be created with tables of numbers and charts all on the same page, something we all take for granted today.
This separate evolution of charts has made it necessary for us to deal with two separate object models for charts. When a chart is on its own stand-alone ChartSheet, then we are dealing with a Chart object. When a chart is embedded in a worksheet, then we have to deal with a ChartObject object.
Was this article helpful?