Copy column from different sheets and plot a graph

  • Thread starter Thread starter Majeed B
  • Start date Start date
M

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
 
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
 
Hi,
Can you explain this a bit more. I am not sure what you mean by this

Regards,

Bivragh
 
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.
 
Back
Top