I have a chart with Project Name as a dimension and sum(Cost) as an expression. I have them sorted from highest to lowest and limited the amount shown to 10 as there are hundreds of projects. I'm creating an automated PPT-report with macros that exports another chart for each of those 10 projects, but can not figure out how to select them automatically.
I managed to make a listbox that holds all of the names sorted by their cost, but that's about it. GetPossibleValues for the field seems to have them in the load order and the function doesn't seem to work for the listbox object.
Can anyone help me out?