Is it possible on a line Chart to have..

[Bobby]

Hi,
Is it possible on a Line Chart to show a line limit in red base on the
Y axis value?(Here 30 is the limit)

40 |____________________________
30 |_____________________________This line would be Red showing the
limit
20 |____________________________ was reached
10 |____________________________
05 |____________________________
00 |____________________________
J F M A M J J A S O N D

Thanks ahead

 

[muddan madhu]

using drawings put a line and change the color of the line.

 

[Bobby]

using drawings put a line and change the color of the line.





- Show quoted text -

Since I am fairly new with charts could you be a little more specific?

 

[Bobby]

using drawings put a line and change the color of the line.





- Show quoted text -

The Drawing ulitity OK! Thanks again!

 

[moily]

Several methods below from Jon Peltier's site

Add a Horizontal Line to a Column or Line Chart: Error Bar Method.
Double click on the resulting error bar, and on the Patterns tab, select a
color and line style for the horizontal line. Here I've chosen a solid red
line. ...
peltiertech.com/Excel/Charts/AddLineHorzErrBar.html


Add a Horizontal Line to a Column or Line Chart: Series Method.
How do you add a nice horizontal line to a column or line chart, to show a
target value, or the series average? The method involves adding a new
series, ...
peltiertech.com/Excel/Charts/AddLineHorzSeries.html

Add a Horizontal or Vertical Line to a Column or Line Chart.
A variation uses an error bar for the straight line, rather than the
connecting line between two points. Add a Horizontal Line to a Column or
Line Chart: ...
peltiertech.com/Excel/Charts/AddLine.html

Column Chart with Horizontal Line Segments.
The values of interest are shown by columns, while the benchmark or target
level is indicated by a horizontal line above each category. ...
peltiertech.com/Excel/Charts/ColumnHorizLine.html

Combining Different Chart Types into a Single Chart.
The vertical red target line and the horizontal black line separating Model
1 from Model 2 are real-life examples of Adding a Horizontal or Vertical
Line to ...
peltiertech.com/Excel/Charts/ComboCharts.html

Add a Vertical Line to a Column or Line Chart: Series Method.
VertizontalLine.zip is a zipped workbook that shows this technique and
others for reliably placing a vertical or horizontal line on your column or
line ...
peltiertech.com/Excel/Charts/AddLineVertSeries.html