Chart With One Series Bars and Two Series of Lines

I am trying to create a chart where weekly sales for 04
are represented by bars and sales for 03 and running
averages are represented by lines. There seem to be many
options for two bars with one line, but not the other way
around. Any ideas? I tried customizing, but couldn't find
a way to change bars to lines.

Thanks!

Brian -

Forget the built in custom charts, make your own. Make your chart with
three line series, then right click on the 04 weekly sales series,
select Chart Type from the pop up menu, and choose a column type for
that series only.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Brian wrote:

I am trying to create a chart where weekly sales for 04
are represented by bars and sales for 03 and running
averages are represented by lines. There seem to be many
options for two bars with one line, but not the other way
around. Any ideas? I tried customizing, but couldn't find
a way to change bars to lines.

Thanks!