stacked bar chart

[upaliwije]

Hi

I want to create a stacked bar chart in My qv document attached herewith. I want to to have two bar chart for Actual and budget.

In the each bar chart % of items give should appear. Pls help me to do this from QV document

[sunny_talwar]

You want a stacked bar chart or you don't want a stacked bar chart?

[upaliwije]

Yes I want  a stack bar chart with two separate bars for actual and budget

[sunny_talwar]

I think may not be possible to do with two dimensions and two expressions. Can you may be remove the MONTH dimension? or is that something you would need to see?

[#5]

Hi,

Stacked bar chart is shown in the qvw provided. If you want grouped bar chart, then remove one dimension (Month in your case).

Regards,

Anjali Gupta

[MK_QSL]

Like this?

[upaliwije]

No harm Month can be removed

[#8]

if Month is removed then your task is done.

[sunny_talwar]

Then I think you just need to remove Month and change from Stacked to Group on the Style tab

[upaliwije]

Your one is some what equal to what I want . Bud the bar should represent % of Come as follows. If we go only upto Gross Profit level

INCOME	5,350,000
CEDED	970,000	18%
UPR	400,000	7%
NET_CLAIMS	2,000,000	37%
ACQ_COST	450,000	8%
GROSS_PROFIT	1,530,000	29%

Total % should be equal to 100%