You are here: HomeExcelTutorials

Graph A Horizontal Line

Graph A Horizontal Line

Price: FREE

I've got a series of data on a line graph. It's nothing too racy - dates and rates.
The rates are on the X axis and the rates are on the Y axis. What I'd like to do is plot a horizontal line across the chart at a given Y value. Say, 4.630. I know I could add a second data series:
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!

Visit publisher's web-site: Graph A Horizontal Line

Category and Tags: ExcelTutorials : : Charts

Related Tutorials

Displaying a horizontal quota line on a graph

Free: Yes
Tags: Excel › Charts

I have a bar graph showing the data that I want to see. Current data runs between say 389 and 1902. The quota for this data say is 100. How can I
insert say a bold horizontal line at the 100 mark on the axis to better show the results to these people as to where they are at versus say what I would call my target line of say 100.

Add a horizontal line to a graph but not to the legend

Free: Yes
Tags: Excel › Charts

I want to be able to add horizontal lines to my chart, in this case at 4% and 6% on the y-axis. The solutions I've seen so far suggest to add a series at these points. The problem is that when I add a series, my legend shows the new series when I don't really want them to. Is there a really simple way that I've overlooked so that I can just add a line at one y-value and all the x values on the graph and not have it appearing in the legend?

Reference line in graph

Free: Yes
Tags: Excel › Charts

I would like to put a reference line in a graph. In other words, I have a value and I would like to have a horizontal line that corresponds to this value, with all other data points surrounding it. That way, viewers of the graph can see how data points compare to this value. Is this possible in

Line Graph in Excel 2007

Free: Yes
Tags: Excel ›

I need to make a line graph for someone at work. Mostly I don't have any problems with it, but this one is a little bit more difficult.
What I need
On the vertical line I need 3 categories (1, 2, 3) with each 7 subcategories (w, k, m, wk, wm, km, wkm). On the horizontal line I need dates. (p.e. 2/2/2011 until 5/2/2011).
I added a drawing to make sure you can understand what I mean. (click on "drawing")
Each date there can only be used 1 subcategory.
Can someone tell me how I can make this line chart?
Li even Van Dame

Horizontal line on a chart

Free: Yes
Tags: Excel ›

I have an Excel 2003 line chart, and I'd like to add a horizontal line across the chart at the value shown in cell C5. I realize I can manually draw the horizontal line, or I can enter that same value in all cells in a new column in the data sheet and plot that as a second series. But isn't there a way to say to Excel, "Draw a horizontal line in the chart at the value corresponding to the value in the cell at C5?"

Related Applications & Scripts

Free: No

Horizontal menu with XML support. You can do items listed below:
You can change name, URL, URL target, line colors,
You can call ActionScript or JS functions.

Horizontal Image Gallery

Free: No
Tags: Flash › Excel Image Galleries

My horizontal image gallery is well commented and allows you to insert as many images as you want. You can even add your own actionscript to open pop up windows displaying a full resolution image, or load an external swf.

Free: No

A basic horizontal Flash menu. Easy to change text of menu items.and you can adjust it to fit any background.

Free: No

XML driven dynamic horizontal-vertical menu with sliding bar line.
Features included:
- Options are configurable via XML
- Horizontal alignment for vertical menu direction (left, right)
- Show / hide bar-line
- Font size, color, rollover color set in XML
- Menu item inactive/rollover alpha set in XML
- X-Y positions of menu set in XML
- URL, target of menu items
- You can select first item to run
- You can enable/disable method call of first item
- Includes WordPress & Joomla plugins
- Includes a html swfObject embed example

Horizontal Two Level Drop Down Menu

Free: No
Tags: Flash › Excel Drop Down Menus

The Horizontal Two Level Drop Down Menu is one of the easiest to use and implement a 2 level horizontal menu from a XML data file. With 20+ XML customization options, this horizontal menu can be used as is or it can be embedded in your project.
Features:
- Dynamic XML Driven
- Fully customizable
- Animation Time Settable
- Unlimited number of items
- Buttons support full color or gradient
- Sub menu blur effect customizable
- Open URL at click