Copy column from different sheets and plot a graph
 

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

Copy column from different sheets and plot a graph
 

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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Majeed B" wrote in message
...
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

Copy column from different sheets and plot a graph
 

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

Regards,

Bivragh

"Don Guillett" wrote:

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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Majeed B" wrote in message
...
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


.

Copy column from different sheets and plot a graph
 

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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Majeed B" wrote in message
...
Hi,
Can you explain this a bit more. I am not sure what you mean by this

Regards,

Bivragh

"Don Guillett" wrote:

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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Majeed B" wrote in message
...
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


.