Creating charts from multiple data sources


show more Creating charts from multiple data sources provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth show less
please wait ...

Creating charts from multiple data sources

You can base a chart on data from nonadjacent ranges, either on the same worksheet at the time you create a chart, but you can even base a chart on data that's on different worksheets, or even different workbooks. However, you must first create a chart before pasting that data in from other locations. Quick reminder here: in this particular sheet right here where there isn't a chart, if we didn't want to show the data for Domestic and Asia, we don't have to hide column C or delete it--in other words we don't want to show Europe--we can simply highlight this data right here, let go of the left mouse button and then hold down the Ctrl key and highlight the Asia data. And if I press Alt+F1, we are going to see a chart here without Europe.

So that's easy and straightforward. But here's a different situation. I have got a sheet called California with California data on it, and Arizona, same layout--and that's not a prerequisite--and Oregon. They just happen to ha...

Creating charts from multiple data sources
Video duration: 3m 39s 3h 36m Intermediate

Viewers:

Creating charts from multiple data sources provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...