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.




Jon Peltier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question