Creating charts from multiple data sources

A common question about Excel charts is, can you create a chart from multiple sources?…The answer is yes, perhaps a qualified yes.…Not exactly obvious. Here's a worksheet called California.…And an adjacent sheet called Arizona and Oregon.…They've got similar data, but that's not a prerequisite.…What we want to show is sales from all three sheets in the same chart.…Now we can put this chart on any sheet we want, I'm going to put it on California to…begin with. And we could possibly move it if we wished later.…

I'm going to select just the data, for the first six months.…Just the sales data. And a quick creation of the chart, Alt+F1.…And there's the chart. We'll move it off the right there.…Let's now go to the Arizona sheet, and highlight the corresponding data.…There it is. Ctrl+C, we'll jump back to California,…click in the plot area in the middle there, press Ctrl+V.…We've added the Arizona data. Let's go to Oregon, do the same kind of thing.…Highlighting the months and the sales number there for the first six months.…