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
From the course: Excel 2016: Charts in Depth
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.