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

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.

"Red" wrote in message
...
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???

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

"Barb Reinhardt" wrote:

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.

"Red" wrote in message
...
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???