Breakeven Chart

I am trying to create a breakeven chart with the expenses as an area chart
and the revenue as a line. Is there a way to mix a line and an area chart on
one chart?

Alan -

Make your chart with both series the same type (Area, say). Select the other series,
choose Chart Type from the Chart menu, and select the chart type you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Alan P wrote:

> I am trying to create a breakeven chart with the expenses as an area chart
> and the revenue as a line. Is there a way to mix a line and an area chart on
> one chart?
>
>

Jon,

Thanks, that was easy. Since I always start from the chart wizard I didn't
think to do it that way. Thanks for your help.

Alan

"Jon Peltier" wrote:

> Alan -
>
> Make your chart with both series the same type (Area, say). Select the other series,
> choose Chart Type from the Chart menu, and select the chart type you want.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Alan P wrote:
>
> > I am trying to create a breakeven chart with the expenses as an area chart
> > and the revenue as a line. Is there a way to mix a line and an area chart on
> > one chart?
> >
> >
>
>