+ 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
    15,802

    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)

Similar Threads

  1. Replies: 0
    Last Post: 09-05-2015, 09:08 AM
  2. Horizontal bar chart with target lines
    By golfoscar in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-08-2014, 03:57 AM
  3. [SOLVED] Connect lines on a actual and target graph
    By makinmomb in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 06-13-2014, 03:20 AM
  4. How to add target line to stacked column pivot chart chart
    By oleg mirzaev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-04-2013, 07:46 AM
  5. Bar chart with 'target' lines but target varies per column
    By Ineedcoffee in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 11-24-2011, 05:41 AM
  6. Replies: 3
    Last Post: 09-11-2010, 06:55 AM
  7. Replies: 3
    Last Post: 03-03-2006, 12:20 AM

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