LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
MDW MDW is offline
external usenet poster
 
Posts: 117
Default Graph A Horizontal Line

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.

--
Hmm...they have the Internet on COMPUTERS now!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bar graph and line graph overlayed MikeR-Oz Charts and Charting in Excel 4 February 6th 06 07:01 AM
Line Graph Help mickeymouse Charts and Charting in Excel 2 January 27th 06 08:39 AM
Line Graph: Differences between series chinois Charts and Charting in Excel 2 January 4th 06 01:36 AM
strange horizontal line showing accross several columns Thrava Excel Discussion (Misc queries) 4 June 29th 05 03:33 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"