Instead of adding the average as another bar, why not add it as a horizontal
line:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Meenie" wrote in message
...
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.