Combining chart data from more than one page
 

I am trying to create a chart by using data from two different pages in my
Excel book. How can I combine the source data from 2 different pages? I.E. I
have years 2001 to 2017 on one page, and years 2018 to 2026 on another page.
I want the graph I'm trying to create, to display the entire range of
years,etc,etc.

Dave,

Probably the easiest thing to do is to create a summary range on the sheet
that contains your embedded chart. The summary range would contain formulas
that reference the chart source range on your second sheet.

----
Regards,
John Mansfield
http://www.pdbook.com

"Dave Tschritter" wrote:

I am trying to create a chart by using data from two different pages in my
Excel book. How can I combine the source data from 2 different pages? I.E. I
have years 2001 to 2017 on one page, and years 2018 to 2026 on another page.
I want the graph I'm trying to create, to display the entire range of
years,etc,etc.

Thank you John. This bit of advice, got me on my way. This is much appreciated.

Dave T

"John Mansfield" wrote:

Dave,

Probably the easiest thing to do is to create a summary range on the sheet
that contains your embedded chart. The summary range would contain formulas
that reference the chart source range on your second sheet.

----
Regards,
John Mansfield
http://www.pdbook.com

"Dave Tschritter" wrote:

I am trying to create a chart by using data from two different pages in my
Excel book. How can I combine the source data from 2 different pages? I.E. I
have years 2001 to 2017 on one page, and years 2018 to 2026 on another page.
I want the graph I'm trying to create, to display the entire range of
years,etc,etc.