Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Help! I'm losing one series of data in an overlay chart. | Charts and Charting in Excel | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Combining Data on a pie chart | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |