2 Replies Latest reply on Jul 8, 2013 3:17 PM by jaimie.stark

    Can I filter out dates from a view containing reference lines?

    jaimie.stark

      I have a bar chart where the X axis is an exact date. I added reference lines to show separation at each month and year, but now when I filter to a specific set of dates the bars for the excluded dates are hidden but the entire axis still displays through the point of the reference line. If I filter to exclude Aug - Dec, I want the x-axis to display Jan - Jul only and hide all of Aug - December including reference lines. If I remove the reference lines the chart filters as desired.

       

      I've attached a sample similar to the structure of my actual workbook. Any assistance would be much appreciated! Thanks!