Combining chart data from more than one page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top