Hi,

Is it possible to create multiple charts (around 9 charts ) in a
single excel sheet? Creating the charts have to be programmatic by
running a VB code. Please somebody provide some help.

Thanks and Regards,
Sobha

In article <(E-Mail Removed)>, (E-Mail Removed) wrote:
>Hi,
>
>Is it possible to create multiple charts (around 9 charts ) in a
>single excel sheet? Creating the charts have to be programmatic by
>running a VB code. Please somebody provide some help.

While I know nothing of VB code, it is certainly possible without it to have
many charts on a sheet by choosing 'as object in' instead of 'as new sheet'
as the last step in the wizard. Perhaps that will give you a place to start
looking ?

Hi,

It's certainly possible to code the creation of charts.

Maybe have a look here.
http://peltiertech.com/Excel/Charts/chartvba.html

The macro recorder, in version prior to xl2007, can also be helpful as a
starting point.

Cheers
Andy

(E-Mail Removed) wrote:
> Hi,
>
> Is it possible to create multiple charts (around 9 charts ) in a
> single excel sheet? Creating the charts have to be programmatic by
> running a VB code. Please somebody provide some help.
>
> Thanks and Regards,
> Sobha
>