Combined line/stacked column chart

[Guest]

Hi, I hope someone can help me!

I am creating a chart showing the revenue, profit, and profit margin for
each of our clients.

I would like to have the revenue and profit appearing as stacked columns
(with values on the left hand Y-axis), and the profit margin as a line over
the top of the columns (with values on the right hand Y-axis). The client
names would appear on the X-axis.

I can only get the profit and revenue to appear as two separate columns for
each job, instead of one stacked column.

Any ideas???

 

[Barb Reinhardt]

Create a stacked column chart with all of the data (including the series
that you want as a line chart).

Select the series you want as a line and right click on the chart and select
CHART TYPE. Change to LINE.

If you want to put the Y axis label for the LINE on the Secondary axis,
double click on the series for the line and select the AXIS tab. Choose
the SECONDARY AXIS.

 

[Guest]

Thanks for your reply. When I create the stacked column chart with all of the
data, only two of the series appear. The third series, which is the one I
want as a line chart, does not appear at all....