Hi,

I am using Excel 2013 to connect to an OLAP Data Source. I am trying to create a stack back that adds the value of two measures:

• Cases that are SLA Compliant
• Cases that are not SLA Compliant

The Axis is the caller name (the customer).

I know how I can sort each independent measure in the chart, but I do not know how to sort out considering all values. Consider this simple example:

(note: I did this test using an Excel table. But in the real scenario the data is coming from an OLAP source).

So if I create a chart, this is what I get in Excel:

As you can see, the chart is not sorted by default. I want to be able to sort from largest to smallest but not either by the blue or by the orange legend -- but by the sum of both legends. That is, the total height of the bars.

Is this possible?

Thanks for the advice and support.

Regards,
P.

• Edited by pmdci 21 hours 22 minutes ago

Add a column to the data source with the total number of cases.

Sort the data source on this column, from largest to smallest.

Delete the chart series corresponding to this column.