Join Dennis Taylor for an in-depth discussion in this video Adding a Data Table, part of Excel 2016: Charts in Depth.
- When you're working with charts and possibly when you've got a worksheet that has multiple charts on it, you might want to add what's called a data table to a chart. Now, a data table is simply a depiction of the source data. Now, adding it to a chart like this, this is adjacent to the data, probably isn't necessary. But you can add one easily in a couple different ways. First thought might be how about this plus button to the right. We are talking about a chart element. It's called a data table. And immediately, you see what's happening to the chart. The source data is being depicted below the chart.
Is it really necessary here since the data is to the left? Probably not. You will also see the same choice if you go to the Design tab, left-most button, Add Chart Element. And there we see Data Table as well. With Legend Keys, No Legend Keys. We could have seen those options earlier too. That too could be helpful. But once again, when the data is adjacent to the chart, probably not necessary. And you'll also see it in some of the Quick Layout options. And the visual is pretty apparent. As you compare this one with others, we see the same thing there.
Now, for different reasons, how about a chart here. Now, this chart's close to the data, but we might have a few other charts on this worksheet too. This one maybe, we don't want to have to keep scrolling back up top and showing the data again. So, maybe we'll add a data table here. The fastest way might be Quick Layout. We saw it already here. Click there. You've got a choice. I think it makes even more sense if you've got a chart that's on a separate sheet. And you may or may not know, when you highlight data, and you want to create a chart, you can create one quickly on another sheet simply by pressing the function key F11.
We see a chart. Now, when you're working with a chart all by itself on its own sheet, the data is not nearby. And if you're about ready to print this after you've done some refinement to it, why not have a data table with it. Because we're not seeing the data here. Quick Layout again. Probably the recommended choice here. The fastest way to get there. Simply choose this option. And you can certainly make other choices. That does look kind of tiny. If I were to use this, I'd click here in the plot area, make the plot area here be a bit taller.
That helps a little bit but not much. So, you might want to explore that a bit. Possibly consider some other changes here. If you went to the plus button here to add Data Table. Explore some options this way. No Legend Keys. Would that help? Not really. So, I think in the choice here, even by going to more options, really not seeing a whole other set of choices here. They could take off the vertical grid lines, the horizontal grid lines. I don't think that's going to help. If you were concerned about how this might look on a sheet of paper, press Control + F2 to get a quick print preview.
We see it there. I think you'd have to print this to decide whether that's big enough or not. We really don't have the capability here to make that larger, so I think maybe that's, maybe not ideal. But, nevertheless, we can see the data with the chart. Now, if the chart is, it's showing less data. I'll go back to the year data sheet here. If we were only showing six months of data. So, here I've got the data highlighted. I'll press the function key, F11. And here, if we add data table, and I'll do it again by way of the Quick Layout button. Here I think it's likely to make a little bit more sense, a little bit more readable.
But maybe not as big as you want it to be. But some options there. Again, going back to the worksheet here. We can add it to these charts as we did before. So, it's just one of those features that's not critical, but yet at the same time, with certain charts, and depending on how you're printing them, you might want to see the data table. And although we're not showing you how to print in this particular movie, if we print this chart only by itself, in other words if we select the chart and then print this, we will see this, and the text will be large enough. And here too. We could do this relatively quickly by simply clicking the File tab and then going down to Print.
And possibly right away here, we'd change this to be, by way of Page Setup, make that be Landscape. And we see how that's going to be effective that way. So, in your printing charts by themselves, it's going to make some sense to possibly include the data table. It shows the data with the chart.
The training wraps up with lesson on changing data sources for charts and printing and sharing charts.
- Identifying chart elements
- Selecting the right chart type
- Creating basic charts
- Creating sparklines
- Styling charts
- Moving and resizing charts
- Modifying axes
- Adding labels and gridlines
- Analyzing data with trendlines
- Inserting pictures, shapes, and text boxes
- Customizing column, bar, line, and pie charts
- Creating Gantt charts and other specialized Excel charts
- Changing data sources
- Printing and sharing charts
Skill Level Intermediate
Q: This course was updated on 03/01/2016. What changed?
A: We added one tutorial about the new Funnel chart type in Excel 2016.