Goal line or target line to Excell 2007 Chart

  • Thread starter Thread starter hawaiiham2000
  • Start date Start date
H

hawaiiham2000

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!
 
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.
 
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?
 
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/tutorial...58-5cecda3e5f09/runtime-dynamic-appconfi.aspx
 
Back
Top