Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Often when you're working with a chart in Excel the data is nearby. You do however have the capability of creating a chart on a separate sheet. And when you do and need to see the data as well, you might consider adding what's called a data table. So, a couple of different options here. There will be times with certain kinds of charts, say that one we're looking at here, adding a data table here, which I'm about to do, probably doesn't help a lot. I'll show you how to add it. Simply select the chart and then on the Layout tab in the Ribbon, let's choose Data Table > Show Data Table. We can show with or without the Legend keys.
Let's show with the Legend keys, since for the moment in this chart we don't have a legend, and you'll see what happens. Now because the data is nearby, this isn't providing us with you know a feature that's absolutely required here. But let's take a look at another example, a line chart sheet. There is one chart already here. Maybe we want to take this data here and create another chart. Put it under this. And furthermore, even while looking at this chart, as we scroll up and down-- you know we do have to scroll up and down to see all of the data-- is it important to see the data here and how might this look? Well, let's take a look at it.
Click this chart, select the Layout tab in the Ribbon, choose Data Table > Show the Data Table with Legend Keys. The legend here is superfluous. We don't really need that. But I think you can see, here the data table is not a good choice. We're not seeing the value with the numbers here. And in order to see them, we either have to use a much smaller font or possibly make this chart a lot wider, and even there, not looking so good here. Data table is not a good choice for this kind of chart. But there could be times when you want to add a data table to a chart.
Maybe it's further down on the sheet, and you want to see all the data. With smaller numbers, this might make some sense. Now what if you have a chart that's on a completely separate sheet? We might start with this data, or maybe I'll go back to the very first sheet, Year Data. I might want to keep this chart here. I'll decide on the data table later, but let's, for example, select this data, and maybe we want to have a chart on a separate sheet. You can get that really fast simply by pressing F11. We now have this chart on the separate sheet.
And no matter what chart type it is, it might make sense here to say, well, let's have a data table with this chart, so every time we look at this we don't have to keep constantly going back to the sheet that contains the original data. So for some people using a data table might be confined only to those charts that are on separate sheets. We'll go to the Layout tab, choose Data Table > Show Data Table, this time maybe without the Legend Keys since we already have a legend, and there we see the data table below the data. And the numbers here, because they're short, can all be seen.
If you want the legend to be included then let's take it off this side. We'll put the Legend on the right side and press Delete. The chart expands a bit. We'll come back to Data Table again, this time with the Legend Keys, and you'll see the difference. The colors are in the legend. So there are certainly going to be times where you want to use a data table. You can emphasize a chart's source data by showing the data right in the body of the chart.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64872 Viewers
80 Video lessons · 124406 Viewers
52 Video lessons · 60330 Viewers
59 Video lessons · 46155 Viewers