Create charts from multiple data sources

- A common question about Excel charts…is "Can I create a chart from data on different worksheets?"…And the answer is yes, perhaps a qualified yes.…In this workbook we've got a sheet called California,…currently visible.…I'll click the Arizona sheet, and the Oregon sheet,…and as I bounce back and forth here,…I think you can see, despite the slight differencies…in column widths, we're looking at the same kind of data,…the same kind of layout.…And maybe what we'd like to show here is a chart…that indicates the sales in all three states…in a single chart.…

And we can put in on any sheet we wish,…perhaps I'll just put it on the California sheet.…So here's the data in question for California right here,…just that data, the Sales.…So a quick way to create a chart,…right in the worksheet Alt+F1.…Eventually I'll move it around a bit but for now…that's just fine.…But I do want to add the data for the other sheets.…So I go to Arizona, click on the Arizona sheet,…and highlight the same relative data.…I don't need to add the months again,…