+ Reply to Thread
Results 1 to 5 of 5

Goal Line or Target Line in Excel 2003

  1. #1
    Registered User
    Join Date
    09-18-2007
    Posts
    53

    Goal Line or Target Line in Excel 2003

    Hello;
    I am looking for assistance in how to build a "easy" target line or target goal within excel. I am thinking it would be a similar to a bar chart that would prefill as specific metrics are met.

    Is this possible?

    Thanks.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Goal Line or Target Line in Excel 2003

    If I am not misunderstanding: create a series of values, all equal to the target value, and plot this series on the chart along with the actual data series.

    Upload a sample workbook showing the desired results if the above is not a viable solution for you.

  3. #3
    Registered User
    Join Date
    09-18-2007
    Posts
    53

    Re: Goal Line or Target Line in Excel 2003

    Thank you for your response.
    I do not have a file... I was just requested to create some type of target goal/line within excel to show folks that targets are being met by specific metrics.
    I found something on the internet but the data was in MS Excel 2007 (which I do not have at the moment).
    Just wanted to see if anyone had any ideas of how to at least start something like this?

  4. #4
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Goal Line or Target Line in Excel 2003

    You're not very clear on exactly what you are looking for.
    Perhaps these tow links will prove useful.

    Charting in Excel - Peltier Technologies

    Andy Pope Charts

  5. #5
    Registered User
    Join Date
    08-18-2009
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    96

    Re: Goal Line or Target Line in Excel 2003

    Not 100% sure what you're looking for either. But to graph a line on a chart (say your "goal line") do the following:
    1) Add a data series to the graph (click on graph, add series)
    2) Choose XY Scatter - The one with the lines - for graph type
    3) Plot X-values along the length of the line. In the attached example, I used .2 and 1
    4) Plot the Y-values at the "goal" number - twice.

    This should give you a "line" on a graph.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1