+ Reply to Thread
Results 1 to 5 of 5

Choosing what lines you want to show in a line graph

  1. #1
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Choosing what lines you want to show in a line graph

    Please see attached doc.

    Is there a way of creating for example an option box for this graph so i can choose what lines i want to look at? For example i just want to look at 2007 and 2009, is the check box function available for me to use for this?

    Help greatly appreciated,

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Choosing what lines you want to show in a line graph

    You can start reading this http://www.peltiertech.com/Excel/Charts/Dynamics.html
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Choosing what lines you want to show in a line graph

    Look here:

    Book1(1).xls

    Now you have two options:

    1) IF values in your table are calculated from somewhere instead of formula you can put =IF(A6=TRUE(), formula, "")

    2) if you enter values manualy you need to create some macro that will take it only if this is true

    (Of course, font in A column make white so you don't see those TRUE/FALSE)

  4. #4
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Re: Choosing what lines you want to show in a line graph

    Thanks for the reply rwgrietveld!

    I have had a look at that link you gave me and also found this
    http://peltiertech.com/Excel/Charts/ChartByControl.html

    I am not finding this easy to follow, could you help me out here please?

  5. #5
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Re: Choosing what lines you want to show in a line graph

    See attached.

    The graph on sheet 3 is what I am looking for help on. there are 3 check boxes where if you click them on click them the series line will appear/disappear on the graph. Which is what i want, I want to add another check box so when you click that all three lines appear/disappear. How can i incorporate that?

    Many thanks!!!
    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