Jon's site
http://peltiertech.com/Excel/Charts/index.html
answers 99 44/100 of all chart questions
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Chenzy_99" wrote in message
...
I am using office 2007 and have a bar graph that simply presents how many
loads of laundry production workers have completed for each day of the
month.
(Each bar displays the total loads per day) over 30 or 31 days. I want to
insert a "target line" accross horizontally to indicate a target amount of
loads per day they should be doing. Is there a way to do this?

The vertical access has the total number of loads and the horizontal
access
indicates the days of the month.

I would like the ability to change the number as the production workers
are
added or subtracted.

The data table has the months accross the top (Ie Jan, Feb ...) , the days
of the month down the side (1st-30th) and the total of loads per day in
the
column for each month. (I have a graph for every month of the year)

Help?

Thank you in advance