how i draw a shart for multi sheet ?

[ahmad]

i have amulti worksheet and i need to make a chart for all

 

[Shane Devenshire]

Hi,

If I understand, you want to create a chart which uses data from multiple
sheets? If so the easiest way is to build a summary area which pulls the
data in from the different sheets and then chart that.

 

[Jon Peltier]

This page adds a little information to Shane's post:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

- Jon