| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plotting 3 column data as mutiple xy scatter plot lines on same graph | Excel Discussion (Misc queries) | |||
| How do I plot multiple series on one graph? - test-graph.xls (0/1) | Charts and Charting in Excel | |||
| How do I plot multiple series on one graph? - test-graph.xls (1/1) | Charts and Charting in Excel | |||
| how do I create a box-plot (or whisker plot ) graph? | Charts and Charting in Excel | |||
| How do I plot both line and column data on same graph? | Charts and Charting in Excel | |||
Hybrid Mode
