Chart functionality

[#1]

Hi All,

I have a query. I have column chart. When I select one of the element of it (Ex. Y axis has month Jan to Dec). When I select one of the month, rest months get invisible. only one month bar column shows. do we have option that if we select any bar , rest should be visible but in deactivated format. As in filter we select any value unavailable shows in Grey background.

Thanks in advance.

[avinashelite]

you need use a macro for this

try like this

sub setreference

set Graph = ActiveDocument.getSheetObject("Object_ID")

1. Graph.SetReference

end sub

[#3]

Thanks avinash. on which event we should run this Macro?

[Anonymous]

Hi,

find the attachment.

u ca change the color of deactivated bars,as follows.

select the expression----->background color-->definition.

Regards,

Murali Mohan .T

[avinashelite]

on open Just add this macro with the chart ID which you need