How can I create a diagram, where datas are in different sheets?

for example:
I have 2 sheets. In each I have datas about 2 shops.
The problem is that I want to compare their year profit in histogram. How can I join both sheet's data in one diagram?

Thanks a lot

Originally Posted by excel_user

for example:
I have 2 sheets. In each I have datas about 2 shops.
The problem is that I want to compare their year profit in histogram. How can I join both sheet's data in one diagram?

Thanks a lot

Hi excel_user,

Here is an example,

Sheet 1
A2:A13 Jan, Feb, Mar, etc
B1 2006
B2:B13 enter numbers
select A1:B13 and select chart wizard and create chart

Assumming Sheet 2 has similar data
Select B2:B13, copy, then go to Sheet 1, slect the chart (not the columns but the whole chart) and paste

Data is now combined into chart on Sheet 1 - Hope this helps, let me know

oldchippy

Thank You a lot
for your immediate answer. I tried your instructions and it really works!

excel_user

Glad to be of help - thanks for the feedback