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.
 
Thank you John. This bit of advice, got me on my way. This is much appreciated.

Dave T
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
Combining a 2-D column graph and a 2-D line graph on the same char 3
scatter and line combined 3
Data disappears when I edit the chart. 1
Cannot combine chart type error with only one chart. 8
how to combine two chart type in one graph 5
Combine two different column charts 2
Add-in for More-Sophisticated Charts 3

Back
Top