2 Replies Latest reply on Oct 4, 2013 11:34 AM by Matt Lutton

    change granularity based on filter

    Sylvia Lawrence

      I have a line chart with date against profit. By default, date is in the 'year' format. I want to display data monthly if months are selected in the date filter. Currently, even if I select month (say last 3 months for example), it still shows 2013 in the year level on the chart. I want the chart to go one step down and show only Aug, Sept and Oct 2013.

       

      Can someone explain any workarounds or solutions with the attached worksheet?