Excel Charts in Queries with Hierarchies

[Former Member]

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

[jaya_mogali]

Hi ,

Since it is a workbook Copy and inset query Twice. Use one result set as source for your Chart and hide this result area. You can use the second result set for navigation.

Jaya