Customizing Chart Type - Stacked Bar and Line Chart

[JD]

I have a a data that has 6 series or coloms of
information - I need to create a bar chart that stacks the
first 5 series and will allow me to have a line series.
The options in the present custom template - only allow
for a non-stacked bar...Can anyone tell me how to do this?

JD

 

[Jon Peltier]

So make your own combination chart. Make a stacked column chart with
all of the data, then select the one series you want to change, choose
Chart Type from the Chart menu, and select a different chart type for
that series.

- Jon

 

[dvt]

I have a a data that has 6 series or coloms of
information - I need to create a bar chart that stacks the
first 5 series and will allow me to have a line series.
The options in the present custom template - only allow
for a non-stacked bar...Can anyone tell me how to do this?

JD

Create the chart with all 6 series in a stacked bar chart. Then select
the series you wish to plot as a line, go to the menu and click Chart |
Chart type and select the line chart or your choosing.