Create charts from multiple data sources

- Most of the time when you are creating a chart in Excel, … you're using data that comes from the same worksheet … where the chart is. … Although you do have the possibility … of creating a chart on a separate sheet. … Let's suppose you want to gather data … in this worksheet called California. … We want to gather data from Arizona and Oregon. … Now maybe a case could be made for putting … all of that data on the same sheet. … But you want to expand these sheets, add some more … and keep the states distinctive on their own sheets. … But let's create a chart here that's going to use … the sales data from each of those different sheets. … We begin by highlighting the data that we want … to appear in the chart initially. … This is going to be from California. … We're on the California sheet. … And we can create a chart quickly by pressing Alt + F1. … It's a column chart, a clustered column chart. … And I'm going to be using this chart type … for the example here. … Now let's go get the corresponding data from Arizona. …