1 Reply Latest reply: Feb 17, 2016 5:10 PM by Stefan Wühl RSS

    Limitting the legend values

    radhika sriramoju



      I have a bar/line combo chart  in which the dimensions are Function and Date .. a Functions can have values ranging from 5 - 25 , as it gets difficult for a user to read along 25 dimensions I want to limit the legend values to 10 , so say for example , user select a function values from the filter and that value has more 10 values I want to display a msg saying too many values , if its less than 10 then the values should be plotted on the chart and also is there a way that user can pick the values in legend like check boxes not dragging and selecting


      Thank you!

        • Re: Limitting the legend values
          Stefan Wühl

          You can create a calculation condition for your chart (on general tab of chart properties), something like


          =Count(Distinct Function) <= 10


          You can change the error message for the calculation condition unfullfilled also on general tab of chart properties to something like

          ='Please select less than 11 Function values'


          If you create a list box for Function with style Windows checkboxes (on presentation tab), you can select / deselect single values. Note that no selections will still be considered 'all values'.