Unsupported Chart Types in Excel

About 30% of the chart types available in IBM® Cognos® Business Intelligence are not matched in the Microsoft Excel spreadsheet software.

The following chart types appear differently or are not supported. Charts that are not supported appear as a default column chart in Excel.

Bipolar charts
Bubble charts
Excel does not support regression lines.
Bullet charts
Excel does not support rectangle fills. As a result, the colored regions in bullet charts do not appear in Excel output.
Combination charts
In Excel, combination charts appear as two-dimensional. If a three-dimensional or two-dimensional combination chart includes only an area, column, or line chart, only the one chart appears.
Gauge charts
Donut charts
Excel may fill in the donut hole to accommodate extra measures. Excel shows donut three-dimensional charts as donut charts.
Maps
In Excel, no chart appears.
Matrix charts
Metrics range charts
In Excel, they appear as combination charts with two line charts for the tolerance bars.
Pareto charts
In Excel, the cumulative line is not displayed.
Pie charts
Excel shows only one type of pie chart and may show it at a different angle.
Progressive column charts
Polar charts
In Excel, a scatter chart appears instead.
Quadrant charts
Radar charts
Excel does not support stacked area radar charts. Excel names area radar charts as filled radar charts. Excel shows radar charts as radar with markers.
Scatter charts
In Excel, three-dimensional scatter charts appear as two-dimensional scatter charts. The z-axis is dropped.
100% stacked bar and column charts
Clustered (side-by-side) stacked column charts are not supported in Excel. Only one column is rendered in the Excel output. For example, you have a 100% stacked column chart with Product line and Order method as columns. In the Excel output, columns for only Product line appear in the chart, but both Product line and Order method appear in the legend.