Chapter 21: Using Advanced Charting Techniques
21
This workbook is available on this book’s website at http://www.wiley.com/go/excel2019bible. The
filename is weather combination chart.xlsx.In some cases, you can’t combine chart types. For example, you can’t create a combination chart that involves a
bubble chart or a 3-D chart. In the Change Chart dialog box, Excel displays only the chart types that can be used.
Displaying a data table
There may be situations where it’s valuable to show all of the data values along with the
plotted data points. However, adding data labels can inundate your audience with a bevy of
numbers that muddle the chart.Instead of using data labels, you can attach a data table to your Excel chart. A data table
allows you to see the data values for each plotted data point beneath the chart, showing
the data without overcrowding the chart itself.To add a data table to a chart, activate the chart and click the Add Element button to the
right of the chart. Place a check mark next to Data Table. Click the arrow to the right of
the Data Table item for a few options. Figure 21.30 shows a combination chart that includes
a data table.FIGURE 21.30
This combination chart includes a data table that displays the values of the data points.Not all chart types support data tables. If the Data Table option isn’t available, this means
the chart doesn’t support this feature.