This content has been marked as final. Show 6 replies
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 ?