Query regarding bar graph

[AbhijitBansode]

I have an requirement of changing bar chart between Groped and Stacked type.

Is it possible to switch the chart type between grouped and stacked on button click(using single bar chart).

[AbhijitBansode]

I have one more requirement for hide and show the value on bars.

Is it possible to hide and show value on bars on button clik(In Single Bar chart)

[maneshkhottcpl]

Hi,

As per my understanding u want the macro to show and hide the expression(Bar) on button clik.

If it is correct. Then please refer the application attached.

[deepakk]

hi Abhijit,

I found a soln for Stack bar. You can check it out.

[AbhijitBansode]

Thank you for solution.

[#6]

Hi,

you try this macro to change stacked bar chart to group bar chart and vise-versa

sub changechartmode
set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties
if(p.ChartProperties.BarModeStacked = false) then
p.ChartProperties.BarModeStacked=true
else
p.ChartProperties.BarModeStacked = false
end if
chart.SetProperties p
end sub

Regards,

Yogesh