Skip to Content
0
Former Member
Nov 18, 2011 at 11:50 PM

Ordering of values in Stacked Area Chart

79 Views

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