bar graphs
 

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

bar graphs
 

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

bar graphs
 

Here is the specific page that will answer the question.

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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