2 Replies Latest reply: Sep 8, 2014 10:21 AM by Mathew Thomas RSS

    Bar chart: what to do if there are data for empty values in dimension

      Hi Everyone,

       

      I have an incomplete dataset whereby I have sales by salesman but then I have sales not done by any of my recorded salesmen.

       

      For example,
      Mr Smith has £3000.00

      Mr Jones has £5004.50

      Mr Thomas has £9000.21

      Mr Taylor has £203.99

      then empty value has £9000000.32

       

      How would in a bar chart I be able to ignore the bar chart representing the empty value?

       

      Thank you