Just go through the presentation tab in the properties window of the chart you are using. Here in the presentation tab, you can hide columns, supress zero values and there are a lot of functionalities given here to modify your chart. Go through it and check what is necessary for you. For your problem just check the box allow pivoting, and also you can give expand always so that the dimensions given in the chart will always remain expanded. Hope this helps you.
You can do that by using the option in presentation. But you must first click on the expression you want to collapse and then check the hide column so that the expression and its coresponding values are not showed in the chart. Hope this helps you....
I am also using QV9. i hope you are using a pivot table. In the presentation window, there is an option to hide coloumn. Please go through it closely,.....
Maybe not useful for the question opener, but still useful for other people. As Joseph already pointed out, the "Hide column" is for Straight table, in Pivot table, in the Expressions tab, you can use the "Conditional" to conditionally hide/display the expression column.
