+ Reply to Thread
Results 1 to 2 of 2

Chart with Target Lines

  1. #1
    Forum Contributor
    Join Date
    12-19-2012
    Location
    Bengaluru
    MS-Off Ver
    Excel 2013
    Posts
    108

    Chart with Target Lines

    Hi all,

    I need help with creating a target line in an excel graph.

    I have 4 parameters for which the targets are set in the beginning of the year. The parameter wise progress is updated month by month in the same sheet.
    I want to create a dynamic graph using check boxes(for which i know the procedure).i.e when i choose parameter1 the monthly data for parameter1 will be visible.

    I want a target line for Parameter that is selected by using a check box (the target remains constant for the whole year) against the monthly details.

    In short - My X-axis will have months and Y-Axis will have numbers.

    Please see the attached sample file with the data.

    Thanks in Advance
    Kittu
    Attached Files Attached Files
    Click on the star * if some1 helped you.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    8,023

    Re: Chart with Target Lines

    It's not clear to me exactly what you want to do. I would suggest you start with this tutorial (http://peltiertech.com/Excel/Charts/AddLine.html ), see if this resolves your question. If not, describe what it did right and what it did wrong.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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