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

"Tushar Mehta" wrote:

See
Adding a horizontal line to a chart
http://www.tushar-mehta.com/excel/ch...nes/index.html
or Jon Peltier's http://peltiertech.com/Excel/Charts/AddLine.html

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Meenie" wrote:

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.