Sourcing Chart Data

Patchcord

Board Regular
Joined
Sep 30, 2003
Messages
73
I have a yearly workbook containing monthy data (1 worksheet per month)

I need to create one chart within the same workbook, showing the yearly result, using data from the other worksheets. Is this possible? I'm not sure how to reference data from worksheets other than the sheet that the chart is on.

Any help would be appreciated.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
"Is this possible?"

Not directly, as far as I am aware. You might be able to do something with a pivot chart using multiple consolidation ranges, but usually you need the data in one place.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,229
Messages
5,571,019
Members
412,354
Latest member
Stj99
Top