I have a stacked area chart that I want to order the stack from highest to shortest based on the last year. The area chart has years and schools on the x axis and count one the y-axis. I want to stack based on the last year of the school count.
When I order it in the chart expert, it seems to pick the first year as the criteria to order the stack.
Is there a way I could use some type of formula or something.
Thanks in advance.
Eric