6 Replies Latest reply: Apr 13, 2012 5:58 AM by Anne Duffy RSS

    Bar Chart 2 colours non stacked

      Hi Guys

       

      Hope you can help I have a data set of

       

       

      Date          Number             Approved

      1/1/12        100                   20

      2/1/12        100                   15

      3/1/12        150                   50

       

      I wish to have a bar chart that shows the bar value as Number and the portion of the bar that is "Approved" in a diff color.

      I did write 2 expressions and stack the bars , but then the value of the bar is actually the total of the 2 , so for 1/1/12 its 120 , rather than 100, with 80 as one color and 20 as another.

       

      I did try using the background function on the bar - but I cant quite get it

       

      Anyone got any advice plaese ?

       

      Thanks


      A