Use the options on the Data Configuration tab of the Chart Types dialog box to create a single chart that combines multiple chart types. You can combine bar, line, and area charts only.
The Data Configuration tab lists the dimensions that appear in the chart legend. If you change which dimensions are on the legend using options in the chart Axes Placement tab, click Apply to have the correct legend dimension members appear in the Data Configuration tab.
To combine chart types:
If
there are more than 28 dimension members on the chart legend, only the first
28 will appear in the Combo Types tab. Use the Axes
Placement tab to adjust which members are on the legend.