How to create a chart that compares monthly data with an average


M

Meenie

Excel 2003:
Jan Feb Mar
Moe 20 24 16
Joe 15 28 24
Flo 25 22 12

Ok lets say the average sales per month for last year was 22.
I want to make a plain clustered column chart that shows what Moe Joe and
Flo each sold for Jan Feb and Mar and want the Average Sale from last year to
be beside each group of columns so each persons sales are compared to the
average from last year.
 
Ad

Advertisements

Ad

Advertisements

M

Meenie

Thanks! I had already used Jon's but can see your's would have worked as well.
Meenie
 

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

Top