Is there a simple way to add a "goal line" or "target" line to a chart? I've
looked at the previous posts and can't seem to figure it out. Thanks!

Hi,

Have you look at these explanations?

http://www.andypope.info/charts/averageline.htm
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html

Cheers
Andy

hawaiiham2000 wrote:
Is there a simple way to add a "goal line" or "target" line to a chart? I've
looked at the previous posts and can't seem to figure it out. Thanks!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Insert following values into new chart

0 $100
1 $100

** Copy Goal
Paste Special into chart
New Series, Series name in First Row
Right click on line
change chart type to smooth

** Right click on "Goal" line
Add Trendline
Options
Custom - Goal
Forward 1.5 Backward .5





Andy Pope wrote:

Goal line or target line to Excell 2007 Chart
11-Aug-08

Hi,

Have you look at these explanations?

http://www.andypope.info/charts/averageline.htm
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html

Cheers
Andy

hawaiiham2000 wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

EggHeadCafe - Software Developer Portal of Choice
Runtime Dynamic App.config / Web.config Editor
http://www.eggheadcafe.com/tutorials...-appconfi.aspx

Yes. On your worksheet, produce a data series that represents the line you
want (in the simplest case Xmin Ymin as one point and Xmax Ymax as a second
point), then add that series as an an extra series on your chart.
--
David Biddulph

"hawaiiham2000" wrote in message
...
Is there a simple way to add a "goal line" or "target" line to a chart?
I've
looked at the previous posts and can't seem to figure it out. Thanks!

So I would just put a column of data next to my data series and use autofill
to copy the same number down for the goal?

But how could I create a horizontal line representing a goal or target that
would go across on a bar chart besides just manual drawing a line?


"David Biddulph" wrote:

Yes. On your worksheet, produce a data series that represents the line you
want (in the simplest case Xmin Ymin as one point and Xmax Ymax as a second
point), then add that series as an an extra series on your chart.
--
David Biddulph

"hawaiiham2000" wrote in message
...
Is there a simple way to add a "goal line" or "target" line to a chart?
I've
looked at the previous posts and can't seem to figure it out. Thanks!

Try the links that Andy posted. Or try this:

http://peltiertech.com/WordPress/200...a-target-line/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"hawaiiham2000" wrote in message
...
So I would just put a column of data next to my data series and use
autofill
to copy the same number down for the goal?

But how could I create a horizontal line representing a goal or target
that
would go across on a bar chart besides just manual drawing a line?


"David Biddulph" wrote:

Yes. On your worksheet, produce a data series that represents the line
you
want (in the simplest case Xmin Ymin as one point and Xmax Ymax as a
second
point), then add that series as an an extra series on your chart.
--
David Biddulph

"hawaiiham2000" wrote in
message
...
Is there a simple way to add a "goal line" or "target" line to a chart?
I've
looked at the previous posts and can't seem to figure it out. Thanks!