From the course: Excel: Charts in Depth

Unlock the full course today

Join today to access over 22,600 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: Charts in Depth

Start my 1-month free trial

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.…

Contents