Results 1 to 9 of 9

Control range in a line chart by hiding/unhiding data columns using data validation lists

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-23-2014
    Location
    Fredericia, Denmark
    MS-Off Ver
    Windows Office 2013, Excel 10
    Posts
    139

    Control range in a line chart by hiding/unhiding data columns using data validation lists

    I would like to use two data validation pull-down lists to hide and unhide columns to define a chronological range on a separate sheet file ("Data"), with the ultimate goal of allowing easy control of the start and stop dates of a line chart on the "Dashboard" sheet file. Each listing in both data validation pull-downs is an annual quarter with a year date ("Q1-2015", for example). By selecting a later date in the second pull-down list, the correct chronological columns in the "Data" sheet file will hide or unhide, and thus the timeframe of the chart in the "Dashboard" sheet file is adjusted. The columns have headers with matching titles "Q1-2015". I'm familiar with many VBA terms but not fluent with Hlookup or Match, Index, etc., and not sure where to start.

    A second condition is that the Stop date in the second validation menu can never be earlier in time than the Start date. And vice versa.

    Attached is a mock-up of what I am trying to create.

    Any ideas out there? I appreciate your help. Thanks. David
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-16-2014, 08:57 PM
  2. Hiding 'zero' values from the chart data range
    By dmbroekhuysen in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-08-2014, 07:58 AM
  3. Replies: 2
    Last Post: 02-04-2014, 03:33 PM
  4. [SOLVED] Chart does not update when hiding/unhiding columns
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-08-2012, 07:51 AM
  5. help with hiding and unhiding a chart based on data
    By elquesito in forum Excel General
    Replies: 0
    Last Post: 05-18-2011, 02:44 PM

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