Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2006

Tip: Looking for answers? Try searching our database.

Graph A Horizontal Line

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MDW - 13 Sep 2006 14:07 GMT
I've got a series of data on a line graph. It's nothing too rancy - dates and
rates.

3/1/2006    4.660
3/3/2006    4.710
3/6/2006    4.760
3/7/2006    4.810
3/8/2006    4.780

The rates are on the X axis and the rates are on the Y axis. What I'd like
to do is plot a horitzontal line across the chart at a given Y value. Say,
4.630. I know I could add a second data series:

3/1/2006    4.630
3/3/2006    4.630
3/6/2006    4.630
3/7/2006    4.630
3/8/2006    4.630

But that seems like an awful lot of extra work for a simple horizontal line.
especially since my actual dataset is quite large. Is there a shortcut way in
Excel I can tell it to just plot a line at a given Y value? Thanks.

Signature

Hmm...they have the Internet on COMPUTERS now!

Bernard Liengme - 13 Sep 2006 16:52 GMT
Jon gives you three ways to do this at
http://peltiertech.com/Excel/Charts/AddLineHorzErrBar.html
best wishes
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> I've got a series of data on a line graph. It's nothing too rancy - dates
> and
[quoted text clipped - 21 lines]
> in
> Excel I can tell it to just plot a line at a given Y value? Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.