From the course: Excel 2016: Charts in Depth

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Create charts from multiple data sources

Create charts from multiple data sources

From the course: Excel 2016: Charts in Depth

Start my 1-month free trial

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…

Contents