merging two data series into one chart?

[jeevesTRAV]

Hello everyone,

I am trying to get a line graph along with a stacked
column graph (each with different values, but with the
same x and y axis) in the same chart. The columns have
forecasted data and the line has actual data.

Is this possible? I can't find any info on this...

 

[dvt]

I am trying to get a line graph along with a stacked
column graph (each with different values, but with the
same x and y axis) in the same chart.

Have you tried Jon Peltier's page? This might be what you want...
http://www.geocities.com/jonpeltier/Excel/Charts/BarLineCombo.html

Dave
dvt at psu dot edu

 

[linda]

There is a customized chart type for two columns and a
line. To find this, select the chart, chart type, go to
the custom type tab, and select the line-column option.

To get the columns to now stack, right click on one of the
colums, select chart type, standard type tab, and choose
the column w/ stack.

I'll try to send an example I worked on directly to you as
well.
Good Luck!
.....Linda

 

[jeevesTRAV]

Thanks again! This has been a real help!

-----Original Message-----
There is a customized chart type for two columns and a
line. To find this, select the chart, chart type, go to
the custom type tab, and select the line-column option.

To get the columns to now stack, right click on one of the
colums, select chart type, standard type tab, and choose
the column w/ stack.

I'll try to send an example I worked on directly to you as
well.
Good Luck!
.....Linda

.