Creating Multiple charts in an Excel Sheet :Post 2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

i.sobha@gmail.com - 30 Apr 2007 10:56 GMT

Hi,

I am posting this for the second time.Please provide me some help.

I need to create a macro in Access which creates a report in an excel
sheet. The excel sheet should contain a number of sheets (Sheet
1,Sheet 2,Sheet 3....).Inside each Sheet around 9 charts have to be
displayed.

Is it possible to create a macro for the same?

Please can somebody help me with some vba code for creating multiple
charts in a single excel sheet.

Thanks,
Sobha

Reply to this Message

Barb Reinhardt - 30 Apr 2007 11:38 GMT

You should be able to find something here for the charting piece.

http://www.peltiertech.com/Excel/Charts/chartvba.html

> Hi,
>
[quoted text clipped - 12 lines]
> Thanks,
> Sobha

Reply to this Message

Bob Phillips - 30 Apr 2007 11:51 GMT

Try using the macro recorder, it should get you started.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi,
>
[quoted text clipped - 12 lines]
> Thanks,
> Sobha

Reply to this Message

Rate this thread: