PDA

View Full Version : Target Line on Plots



nick99
07-25-2007, 10:46 AM
I need to know how to setup a target for a simple line plot.

Eg:
I have certain values in column A. I use a line type graph to plot it.
To see how the graph performs i need to show a target line all the way across the plot. (this line should intersect the Y axis)

also i need to know how to set the this plot up if the target line value is dynamic.

daniel_d_n_r
07-25-2007, 01:48 PM
A column of target values maybe?
Not sure what you want..
It would depend if the target values depended on other data or depended on your current plot values.

JonPeltier
07-28-2007, 07:14 AM
Add a line to a chart:

http://peltiertech.com/Excel/Charts/AddLine.html

Not VBA but wouldn't be too hard to automate.