>>Does someone know how to combine 3-D bar chart with a target line?
>
>By "target line," do you mean a series graphed as a "regular" (2D) line? If that's what you mean, I'm afraid you're out of luck as you can't combine 2D and 3D charts.
>
>However, there is a 3D line chart type. You can set this like so:
>

#DEFINE xl3DLine -4101
>oExcel.ActiveChart.SeriesCollection[1].ChartType = xl3DLine

>
>Does this answer your question?
>
> - della

No, there is no way to combine 3 and 2-d charts.
Mark