You have to add a series to highlight a gridline or target line:
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Wanda" wrote in message
...
Hello all!
I'm using Excel 2003, and have a charting question: I'm charting some
ratios for my work on a line chart, but would better like to show whether
the
said ratio is "above" or "below" our target by somehow accentuating the
"target" on the Y axis. I don't want to create a series called "target"
and
plot it on the chart.
For example, one of my charts has major Y axis numbers of .05, 1, 1.5 and
2.
Our "Target" for this particular chart is 1. How can I accentuate this
particular axis line on the chart to immediately see at a glance if a
particular point is above target or below target??
Much thanks in advance.