Article ID: 240263 - View products that this article applies to.
This article was previously published under Q240263
This article has been archived. It is offered "as is" and will no longer be updated.
This article describes how you can create a combination chart using the Chart Office Web Component.
A combination chart can include Series with Columns, Lines, or Areas. To create a combination Chart, set the Type property of each series. To illustrate, you could use the following code to create an Area/Column combination Chart from a Chart with two series:
Notes About Chart and Series TypesBoth Charts and Series have a Type property. Setting the Type property of a Chart object changes the chart type for every Series in the Chart. Note that if you query the Type property of a combination Chart, the returned value is chChartTypeCombo (or -1). chChartTypeCombo indicates that the Series on the Chart has different types. You cannot set a Chart Type to chChartTypeCombo; if you do, you receive an error.
As mentioned earlier, a combination Chart can consist only of Series with types Column, Area, or Line. If you attempt to change a Series on a Chart to an incompatible type, all the Series types on the chart are changed. In other words, you change the Type property of the Chart object itself.
Notes About Value AxesA combination chart can have two value axes. The Value axes on a chart always have the same scale. In a scenario where you have two series where the y-values are considerably different in value, the Series with the smaller values may look "dwarfed" by the Series with the larger values. Unfortunately, when using the ChartWeb component there is no way to avoid this behavior because the value axes cannot have different scales.
There are alternatives you might consider for using two series with very different values:
(https://support.microsoft.com/kb/286211/ )How To Create a Combination Chart Using the Office XP Chart Component or the Office 2003 Chart Component
For additional information about using the Chart Web Component, please click on the number below to view the article in the Microsoft Knowledge Base:
For information about programmatically creating a GIF file from a Microsoft Excel Chart, please click on the number below to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/235885/EN-US/ )How To Use the Office Chart Web Component With VB
(https://support.microsoft.com/kb/163103/EN-US/ )How to Create a GIF File from a Microsoft Excel Chart
Article ID: 240263 - Last Review: October 22, 2013 - Revision: 2.2