D
David Leblond
I have a pivot chart (bar chart) in my application that I would like sorted.
I can do it by right clicking on one of the bars and selecting "Sort
Ascending by Total." Easy enough. Problem is, we deliver the application in
MDE format. For some reason right clicking anywhere in the Pivot Chart in
the MDE results only to a shortcut menu with the item "Properties."
So I started looking into how to perform the sort in VBA and so far I have
found nothing. There has to be a way to do it, does anyone know?
I can do it by right clicking on one of the bars and selecting "Sort
Ascending by Total." Easy enough. Problem is, we deliver the application in
MDE format. For some reason right clicking anywhere in the Pivot Chart in
the MDE results only to a shortcut menu with the item "Properties."
So I started looking into how to perform the sort in VBA and so far I have
found nothing. There has to be a way to do it, does anyone know?