Goal line or target line to Excell 2007 Chart

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" <hawaiiham2000.DeleteThis@discussions.microsoft.com> wrote in message
news:7B90B9D5-2617-4DAE-A2B3-D6FE1DAD1185@microsoft.com...
> 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" <hawaiiham2000.TakeThisOut@discussions.microsoft.com> wrote in message
> news:7B90B9D5-2617-4DAE-A2B3-D6FE1DAD1185@microsoft.com...
> > 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/2008/07/29/add-a-target-line/

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


"hawaiiham2000" <hawaiiham2000 DeleteThis @discussions.microsoft.com> wrote in message
news:ABBD3EFC-3A14-4015-89C9-E78F5CE8622C@microsoft.com...
> 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" <hawaiiham2000 DeleteThis @discussions.microsoft.com> wrote in
>> message
>> news:7B90B9D5-2617-4DAE-A2B3-D6FE1DAD1185@microsoft.com...
>> > 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!
>>
>>
>>

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:

Re: 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/straight_lines/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/aspnet/8e1a1f80-6002-4d75-9e58-5c...a3e5f09