I have a chart which tracks workhours per week. Across the bottom are the
dates representing the ends of the weeks (1/7/07 through 12/30/07), and along
the left are possible hours per week (0 through 70). I am using a line chart
with markers.

I would like to add a base line or indicator line across the chart at 45
hours.

How can I add a base line at 45 hours. (I don't have the base line data in
my spreadsheet.)

Thank you for your help.

Darrell

Add a line to a line or column chart:

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

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


"Dr. Darrell" wrote in message
...
I have a chart which tracks workhours per week. Across the bottom are the
dates representing the ends of the weeks (1/7/07 through 12/30/07), and
along
the left are possible hours per week (0 through 70). I am using a line
chart
with markers.

I would like to add a base line or indicator line across the chart at 45
hours.

How can I add a base line at 45 hours. (I don't have the base line data in
my spreadsheet.)

Thank you for your help.

Darrell

Jon:

Thank you, that was very helpful.

Darrell

"Jon Peltier" wrote:

Add a line to a line or column chart:

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

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


"Dr. Darrell" wrote in message
...
I have a chart which tracks workhours per week. Across the bottom are the
dates representing the ends of the weeks (1/7/07 through 12/30/07), and
along
the left are possible hours per week (0 through 70). I am using a line
chart
with markers.

I would like to add a base line or indicator line across the chart at 45
hours.

How can I add a base line at 45 hours. (I don't have the base line data in
my spreadsheet.)

Thank you for your help.

Darrell