Charting between different worksheets

[1heng]

I have 6 differnet worksheets based on its years. 1996 - 2001.

Each column is represented by different countries, and each row is represented by different types of wine.

The last row is total quantity of wine sold within a certain country.

The graphs must be shown like this:

x - axis = year (1996 - 2001)
y - axis = total quantity of wine

but how do i do this since the value of total wine sold for each year is in a different worksheet? Is there no simple way of doing this apart from copying and pasting the values in to a new and separate worksheet?

Thanks in advance.

[oldchippy]

Hi 1heng,

Welcome to the forum, don't cut and paste but bring the data you need to the summary page with formulas linking each sheet. So if you were to change the quantities in your separate sheets, then the chart gets updated automatically. It's also easier to see all the data on one sheet that it related to the chart.

Hope this helps?