create stack and group bars in a same graph

[#1]

hi all

i would like create actual and projection in group ,whereas stack bar needs to be used for Allocation

[Gysbert_Wassenaar]

Yes, add two dimensions to your chart and select the option Stacked on the Style tab. You will get groups of stacked bars in your chart. If you want Allocation stacked then make it the second dimension in the chart.

[#3]

Hi, by using below macro you can maintain both stacked an group style in single graph.

Sub ToggleChartBarStack

dim chart

dim cp

set chart = ActiveDocument.GetSheetObject("CH29")

set cp = chart.GetProperties

If cp.ChartProperties.BarModeStacked = true then

cp.ChartProperties.BarModeStacked = false

else

cp.ChartProperties.BarModeStacked = true

end if

chart.SetProperties cp

end sub

[rohan_mulay]

Hi Jayanthan,

Add 2 dimensions in a bar chart and 2 expressions and select Stacked style.

I have following data:

City,Population,Month

Mumbai,20,Jan

Pune,40,Jan

Mumbai,35,Feb

Goa,31,Jan

Mumbai,60,Mar

Pune,25,Feb

Pune,56,Apr

Goa,31,Feb

Goa,31,Apr

Add City and Month field in dimension and specify 2 expressions for the data. Here I have used following expressions:

=sum(Population+68)

=(sum(Population))

This gives following output where for City Goa we get Group of bars specifing Months and representing the values for both of the above expressions

[Anonymous]

Hi,

Look into attached file.

[#6]

thank you all.

Sorry, i have miscommunicated earlier. I want Actual and Projection in Stack ,whereas allocation as another bar(since i do not how to have stack and group in  a same chart, i have put allocation in line chart). {

Please refer the below screen shot

[#7]

hi satya

it doesnt work for me. Kindly help to solve this issue

please refer the attached QVW

[Anonymous · Accepted solution]

See attachment

[#9]

superb Satya

thank you .

Can i know where i went wrong

Jayanthan

[Anonymous]

Hi Jayanthan,

You need to add "TypeID" in dimension of your chart and adjust expression with "Type" so that it will group in "Budget" and "Projection & Sales" category.

Thanks