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" <(E-Mail Removed)> wrote in message
news:68737298-7692-405B-A86A-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:68737298-7692-405B-A86A-(E-Mail Removed)...
> > 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???
>
>
>