Excel Charts in Queries with Hierarchies

Hi All,

I have a requirements of showing the data out of a query in workbook which has hiearchy. When I collapse the hierarchy the chart source data is changed and when I reopen the hiearchy the graph is not coming to as it is original. The chart setting is getting distrubed. I dont want that to happen. Can any one give me a solution on this.

Thanks in Advance,

PV