Creating multiple charts in an excel sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

i.sobha@gmail.com - 11 Jun 2007 09:44 GMT

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

Reply to this Message

Bruce Sinclair - 12 Jun 2007 00:19 GMT

>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 ? :)

Reply to this Message

Andy Pope - 12 Jun 2007 21:03 GMT

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

> Hi,
>
[quoted text clipped - 4 lines]
> Thanks and Regards,
> Sobha

Reply to this Message

Rate this thread: