Hi,

You just need to add another series where each value is the required
goal for that period. You can then format the line series as you wish.

Cheers
Andy

TJH wrote:
I'm making a piece per month chart with a line chart. Say our goal every
month is 5000 pcs per month. How do I make a line and either make it larger
(darker) or name it as our goal line to show if we are hitting our goal each
month?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info