Populating stacked bar and bar in a single chart

[#1]

In a single bar chart, can we populate one bar as stacked bar containing various region wise sales and beside that I should have a bar (with out stack) populating the product wise sales.I tried to accomplish the above by using container object by hiding the dimension but not able to hide the Y axis dimension of second chart

[Anonymous]

Anil

Would it suffice to have two chart objects side by side, one a bar chart and the other maybe a Gauge style thermometer ?

Best Regards,     Bill

[MK_QSL]

Can you provide some sample data?

[#4]

Hi Bill,

Thanks for the reply, I need to show one data set as stacked bar and the other data set as bar chart in a single object itself. Will it be possible to show the something like that.

[Anonymous]

Anil

No you cannot do that in a single chart object.  You will need to use 2 objects.

Best Regards,     Bill

[MK_QSL]

We can do this by using two different chart and overlapping one on another.. Kindly provide your sample date, we can do the same....

[#7]

Hi Manish,

I can share the schema, but I cant upload the sample data file. I have created two different objects, one is populating the stacked bar, and the other populating bar chart, I placed the two objects in a container object and I masked all the caption settings made it, to appear like a single object. but am not able to hide the y axis of second object. please go through the below schema.

APAC	prod1	APACSaleperson1	500
EURO	prod2	Eurosalesperson1	600
AMER	Prod3	AmerSalesperson2	700
NAM	Prod4	NAMSalesperson2	800
APAC	prod4	APACSaleperson1	900
EURO	prod7	Eurosalesperson2	200
AMER	Prod8	AmerSalesperson1	300
NAM	Prod9	NAMSalesperson1	400

[#8]

Hi,

I am also looking for solution for the same question.

but i didnt find the answer yet.

can we use any offset concept here, to create stacked bar?

[Clever_Anjos]

You should two objects side-by-side