Results 1 to 5 of 5

Create variance slider?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-25-2010
    Location
    Virginia
    MS-Off Ver
    Excel 2013
    Posts
    104

    Create variance slider?

    The attached sample file is a very small example of a data set I am working with.

    You will see I've used a combination of a scroll bar and conditional formatting to created a level of interactivity with the data. (This technique was thanks to one of you wonderful folks here on the forum.) As you move the slider, cells whose values are below the slider value disappear (via having their text color changed to white in the conditional formatting.)

    This technique is really great. I'd like to add another slider to highlight the amount of variance from month-to-month for each group.

    My actual spreadsheet is much larger than this and I really cannot add new columns to hold variance values. Another challenge is the way the data is laid out with Jan through Jun being repeated.

    I want another slider that will be 0% to 100%, and it will color in red those values whose variance from the previous month are above the current slider value.

    Since there is never a "previous month" for the Jan values to be compared against, they should never get colored.

    I hope I've described this well enough for someone to be able to help me.
    Attached Files Attached Files
    Last edited by SueWithQuestion; 10-04-2010 at 06:49 AM.

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