Skip to Content
Former Member
Dec 20, 2007 at 03:19 PM

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,