Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 15
Default Goal line or target line to Excell 2007 Chart

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!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Goal line or target line to Excell 2007 Chart

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
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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" 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!



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 15
Default Goal line or target line to Excell 2007 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?


"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!




  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Goal line or target line to Excell 2007 Chart

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!








  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Goal line or target line to Excel 2007 Chart

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a goal or target line Lintless Charts and Charting in Excel 1 February 22nd 08 07:01 PM
Target line to a column chart? Deb Charts and Charting in Excel 2 September 14th 07 12:50 PM
How do I add a target line to a chart? soconfused Charts and Charting in Excel 1 June 15th 07 02:52 PM
target line in bar chart chinascot69 Charts and Charting in Excel 1 July 28th 06 12:50 PM
Chart Target Line AlDeb Charts and Charting in Excel 1 October 11th 05 05:29 PM


All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"