+ Reply to Thread
Results 1 to 3 of 3

Applying filters to Timeline Chart

  1. #1
    Registered User
    Join Date
    03-21-2014
    Location
    Diss, Norfolk, England
    MS-Off Ver
    Microsoft 365 Excel
    Posts
    57

    Applying filters to Timeline Chart

    Enclosed is a timeline (template, courtesy of Microsoft Office), which worked well for my initial purposes. However, I need to be able to "filter" the source table (Columns B to E) and ideally for the chart to reflect the applied filters (e.g. hide/display milestones accordingly). I went through lengths to understand the construction; alas, no luck as I am a novice chart developer. I wondered if this is possible and without macros. Can anyone help, please? Any advice or instructions would help greatly. Million thanls in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    22

    Re: Applying filters to Timeline Chart

    Try this attached file.. u can use filter the dates which u dont want to show..
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-21-2014
    Location
    Diss, Norfolk, England
    MS-Off Ver
    Microsoft 365 Excel
    Posts
    57

    Re: Applying filters to Timeline Chart

    Hi Vikas,
    I appreciate your help. Presentationally, I need the chart to be same as my original; your version works well but shows everything in one line whereas I need to make use and include the seconrdary series bar-chart for label "height" (see 'position' column on my original source table). I will continue to play in attempt to resolve it but might be faster if someone with experience can help; therefore, I am most grateful if you can figure out how we can best use my existing table rather than re-design a new chart (note: my original spreadsheet has hidden column 'H' - same as your column 'L').

+ 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. Selecting visible rows post applying filters
    By Raghukumarn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2014, 06:41 AM
  2. [SOLVED] How to get correct values without applying filters
    By SunOffice in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-24-2013, 06:30 PM
  3. Checking values between cells and then applying filters/hide rows
    By andie2013 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2012, 11:28 AM
  4. Applying filters
    By jimz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2011, 07:49 AM
  5. Replies: 1
    Last Post: 10-24-2007, 08:31 PM

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