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.

Change the location of a chart's source data

Change the location of a chart's source data

From the course: Excel 2016: Charts in Depth

Start my 1-month free trial

Change the location of a chart's source data

- Sometimes you recognize that a chart is showing too much data or not enough data. In this worksheet called YearData, as I click the chart to the right, notice in the data to the left over in columns A through D we see what's highlighted and so it's pretty clear which data is being shown in the chart. So what if we decide we really don't want to see Asia in this chart? A couple ways to approach this. With the data being highlighted, I'm going to point to the lower-right-hand-corner and click and drag leftward. Let go of the mouse, watch the chart, and we see the change there. Now, possibly when I created the chart, it could be looking like this, I only wanted Domestic and Europe. Imagine that that's the way I created the chart, and I click the chart and say, I want to include Asia. Well I can drag that lower-right-hand-corner rightward. So we've added Asia. Another approach, a different thought. You're looking at the data and you say, for the moment, I don't need to see Europe in…

Contents