4 Replies Latest reply on Nov 13, 2018 9:25 AM by Leyla Hunn

    Can't make graphs show all values again when clicking on corresponding graph

    Leyla Hunn

      Hello,

       

      Every time I click on any part of my first line graph (the coloured one on the left - pictured below), the pink and blue line & bar graphs on the right change, which is what I want it to do. My problem is that when I click on the same spot of my first line graph, the pink and blue bar & line charts on the right do not go back to the way they were before (showing all values of the entire graph), the filters remain as they are.

      I have tried going to 'actions' and 'show all values' but the problem is that by clicking on 'show all values' for the filter, it literally shows ALL values, even the ones that I have filtered out for the graph, which I do not want. Could anybody help me with this? I've attached my workbook too.

       

       

      Thank you,

      Leyla

      How can I make my line and bar charts on the right go back to showing all values?