I have created a pivot table in QV with Financial Year(FY) and value. I sort the FY by descending so that the latest FY is showed on top. I then enable the "Fast Type Change" to allow both Bar Chart and Pivot Table to be shown in the same object.
However, in the bar chart mode, the latest FY is presented at the left, eg. FY2009-10 -> FY2008-09 -> FY2007-08. I understand that this is because it's sort by descending.
I am wondering if there's any method to allow me to have the FY sort in descending in Pivot table mode but ascending in the bar chart mode (as shown in the chart at the right in attached file).
I don't think there's a way, as I don't know of way to trigger a macro on that particular event. A less elegant way would be to use a button the do the switch instead of the fast type change button, but it could be confusing to the user.
Thanks. I'm thinking if there's something that can identify if the chart type is bar chart or pivot table. Eg. if chartType=$barchart, sort FY by ascending, else descending.
