Closed Thread
Results 1 to 6 of 6

toggle data series on/off on chart

Hybrid View

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    69

    Re: toggle data series on/off on chart

    Does anyone have any suggestions?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

    Re: toggle data series on/off on chart

    The attached shows how you can do this for your 5 curves. I've inserted a new column Q so that the Y values for the graph are now derived from column R. I've copied the Y values into column Q, then put this formula in R3:

    =IF($V$35="Y",Q3,NA())

    and copied this down. Similar formulae have been put in each block further down the column, but referring to V36, V37 etc.

    So, change the values in V35:V39 from Y to something else (N ?) and the appropriate set of curves will disappear from the graph. You can apply similar logic to the other data sets.

    Hope this helps.

    Pete
    Attached Files Attached Files

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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