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?