electron

Mixing Two Chart Types on a Single Chart in Excel 2007:-

Although the Chart Type dialog doesn’t offer it as a choice anymore, you can represent a chart’s series with different chart types. Instead of two lines on a chart, you can show one series as a line and one series as columns. Or you can mix columns and area charts, as shown in the Figure (given below).



(To emphasize one series, you can mix chart types on a single chart.)

To change the chart type for a series, you rightclick the series and choose Change Series Chart Type from the context menu.

You can mix only certain chart types. For best results when mixing chart types, follow these guidelines:

1. You should stick with 2-D chart types. Excel does not let you mix 3-D charts.

2. 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.

3. 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.

4. You can mix circular charts. You can, for example, change one series of a doughnut chart to a pie chart.

5. Remember that in many cases, a line chart can be changed to an XY scatter with line series. The advantage is that up/down bars and hi-lo lines ignore an XY scatter chart line.