merging two data series into one chart?

  • Thread starter Thread starter jeevesTRAV
  • Start date Start date
J

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...
 
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
 
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

.
Click to expand...
 
Back
Top