Create Chart from ??? Sheet !

Originally Posted by Herve_Rob

Hi All,
Anyone to help me ?

In my XL File, I have 15 Sheets
I have created a Form that contain:
- 1 Select List (Selection of Name (1 of the 15 Sheets)
- 1 Select List (Selection of 3 Choice (Linked to Column D, E & F)
- 1 Button (validation)


For Example:

Sheet 1 = TATA
Sheet 2 = TETE
Sheet 3 = TOTO
Sheet 4 = .....

For all Sheets, in Column D Values are Sum
in Column E Values are Delta
in Column F Values are Percent

From the Form, if I select "TATA" & "Percent", then after clicking the Button, It generates a Chart with data from Column F in Sheet TATA.

Could anyone Help me with the Code !!

Regards
RV

Hi,

the thread http://www.excelforum.com/showthread.php?t=587394 has just successfully created charts in multiple worksheets.

hth
---