View Full Version : Target Line on Plots

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

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.

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.

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


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