Create average line in chart

**booo** · 10-18-2010, 02:43 PM

I have created charts for data involving the number of parts that is bring bought every month. I have 'months' along the x-axis and 'number of parts' along the y-axis.

I want to create an average line to show if for a particular month, the number of parts is above the average number of parts per month.

Is this possible?

**DonkeyOte** · 10-18-2010, 02:59 PM

dupe post: http://www.excelforum.com/excel-char...ntal-line.html

please post your question once only - if you feel you've posted to an inappropriate forum please contact a Moderator to either move or remove the offending thread.