You can mix only certain chart types. For best results when mixing chart types, follow these
guidelines:
■ You should stick with 2-D chart types. Excel does not let you mix 3-D charts.
■ Within the 2-D types, you should mix only clustered chart types. Excel doesn’t, for
example, stack a stacked area chart on top of stacked columns.
■ You can’t mix vertical types with horizontal types. You need to keep columns, lines, and
area charts together because bar charts don’t mix with them.
■ You can mix circular charts. You can, for example, change one series of a doughnut
chart to a pie chart.
■ Remember that in many cases, a line chart can be changed to an ...