Embedded Charts or Chart Sheets

[shades]

I use Charts alot in my work. For the most part I use Embedded Charts, for convenience (i.e., see the table and chart at the same time), and that was the way I began 5 1/2 years ago. Most of my code for working with charts deals with Embedded Charts. However, I occasionally run into groups in our company who use nothing but Chart Sheets.

From a VBA perspective, which do you prefer to work with, and why?

[Aaron Blood]

I just like putting more than one of em on the same sheet... Also something comforting about locating the charts in the same place as the associated data.

Pssst... BTW, not too many people know that you can still get a full sheet printout of an embedded chart by just selecting the chart object (activate it) and then press the Print Preview button.

I s'pose there are occasions when it would be more appropriate to use a chart sheet though.