Copy column from different sheets and plot a graph

[Majeed B]

Hi,

For Excel 2007, In one sheet I have 60 columns and I have 5 different sheet
with same no of column. I want to make a graph (basically 60) corresponding
to each column in the 5 sheet.
So make a graph from sheet 1-5 of column A, B,.... XX
Can anyone suggest a marco to do all this in one go

Thanks

 

[Don Guillett]

You don't have to copy to do that. Set up a series for each sheet's column
=Sheet1!$A$1:$A$10
=Sheet2!$C$1:$C$10

 

[Majeed B]

Hi,
Can you explain this a bit more. I am not sure what you mean by this

Regards,

Bivragh

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.