Combining chart data from more than one page

[Dave Tschritter]

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.

[John Mansfield]

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.

[Dave Tschritter]

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.