Bar Chart 2 colours non stacked

[#1]

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

[CELAMBARASAN]

Hi,

     Then Create a bar chart with date as dimension with 2 expressions as

     Exp1:Sum(Number)-Sum(Approved)

     Exp2:Sum(Approved)

     and stacked it.

Celambarasan

[Anonymous · Accepted solution]

Hi, Is this what you want to achive? /Marcus

[#4]

Check this application

[#5]

So Simple --- Thanks a mill guys

One more quick ( and this might be stupid!!)

But how do I attach a QV doc to a thread ??

Thanks

[CELAMBARASAN]

Hi,

     click the link Use advance editor which is at the right top of the editor.

Celambarasan

[#7]

Thanks