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
From the course: Excel 2016: Charts in Depth
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…
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.
Contents
-
-
-
-
-
Add a chart element3m 58s
-
Choose a chart layout with the QuickLayout option3m 55s
-
Select chart colors using Colorful and Monochrome palettes3m 38s
-
Style charts using the Design gallery or paintbrush icon2m 32s
-
Switch rows and columns for a different view of the data3m 17s
-
Change the location of a chart's source data4m 7s
-
Work with empty and hidden cells6m 22s
-
Change a chart's type2m 22s
-
Change the default chart type and save it as a template4m 54s
-
Change the location of a chart1m 39s
-
Move and resize a chart within a worksheet5m 6s
-
-
-
-
-
-
-
-
-